/*
 Navicat Premium Data Transfer

 Source Server         : 国医堂正式服务器
 Source Server Type    : MySQL
 Source Server Version : 50718
 Source Host           : rm-2zee28k1n7zndw92goo.mysql.rds.aliyuncs.com:3306
 Source Schema         : massage_child_pro

 Target Server Type    : MySQL
 Target Server Version : 50718
 File Encoding         : 65001

 Date: 28/04/2018 11:02:05
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for account_doctor_info
-- ----------------------------
DROP TABLE IF EXISTS `account_doctor_info`;
CREATE TABLE `account_doctor_info` (
  `account_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '医生提成表主键ID',
  `booking_id` int(32) DEFAULT NULL COMMENT '预约号',
  `order_id` int(32) DEFAULT NULL COMMENT '订单号',
  `doctor_id` int(11) DEFAULT NULL COMMENT '医生id',
  `user_name` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '会员姓名',
  `detail_name` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '服务项目',
  `order_pay_cost` decimal(10,2) DEFAULT '0.00' COMMENT '提成金额',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`account_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='医生提成流水表';

-- ----------------------------
-- Table structure for account_order_info
-- ----------------------------
DROP TABLE IF EXISTS `account_order_info`;
CREATE TABLE `account_order_info` (
  `account_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `booking_id` int(32) DEFAULT NULL COMMENT '预约单号',
  `order_id` int(32) DEFAULT NULL COMMENT '订单号',
  `order_total_cost` decimal(10,2) DEFAULT '0.00' COMMENT '实收金额',
  `order_pay_cost` decimal(10,2) DEFAULT '0.00' COMMENT '应收金额',
  `coupon_total_cost` decimal(10,2) DEFAULT '0.00' COMMENT '优惠金额',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `subclinic_id` int(11) DEFAULT NULL COMMENT '分店id',
  `doctor_id` int(11) DEFAULT NULL COMMENT '医生id',
  PRIMARY KEY (`account_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='订单流水表';

-- ----------------------------
-- Table structure for account_user_info
-- ----------------------------
DROP TABLE IF EXISTS `account_user_info`;
CREATE TABLE `account_user_info` (
  `account_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '流水表主键ID',
  `account_no` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `order_id` int(11) DEFAULT NULL,
  `card_no` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '卡号订单',
  `card_id` int(11) DEFAULT NULL COMMENT '充值的卡的ID',
  `cashier_id` int(11) DEFAULT NULL COMMENT '销售人员ID',
  `user_id` int(11) DEFAULT NULL COMMENT '用户ID',
  `account_cost` decimal(8,2) DEFAULT '0.00' COMMENT '金额',
  `card_type` int(1) DEFAULT '0' COMMENT '类型：0:余额;1:次卡;2:储值',
  `subclinic_id` int(11) DEFAULT NULL COMMENT '分店id',
  `account_desc` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '备注',
  `account_type` int(11) DEFAULT NULL COMMENT '类型：0:消费;1:充值',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP,
  `pay_way` int(11) DEFAULT NULL COMMENT '支付方式:0:余额;1:支付宝二维码;2:微信二维码;3:现金;4:信用卡;5:次卡',
  PRIMARY KEY (`account_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='用户充值帐户流水表';

-- ----------------------------
-- Table structure for init_advert
-- ----------------------------
DROP TABLE IF EXISTS `init_advert`;
CREATE TABLE `init_advert` (
  `ad_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '轮播图ID',
  `ad_name` varchar(40) CHARACTER SET utf8 DEFAULT NULL COMMENT '轮播图title',
  `ad_image` varchar(200) CHARACTER SET utf8 DEFAULT NULL COMMENT '轮播图img',
  `ad_index` int(11) DEFAULT NULL COMMENT '自定义index',
  `skip_url` varchar(200) CHARACTER SET utf8 DEFAULT NULL COMMENT '轮播图跳转url',
  `ad_status` int(11) DEFAULT '0' COMMENT '当前状态:0-启用 1-下线',
  `ad_start_time` datetime DEFAULT NULL COMMENT '轮播图有效期-开始时间',
  `ad_end_time` datetime DEFAULT NULL COMMENT '轮播图有效期-结束时间',
  `ad_type` int(11) DEFAULT NULL COMMENT '类型：0轮播图，1广播',
  `subclinic_id` int(11) DEFAULT '0' COMMENT '分店ID（当为0时为总店）',
  `create_user_id` int(11) DEFAULT NULL COMMENT '当前创建人',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`ad_id`) USING BTREE,
  KEY `create_user_id` (`create_user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='轮播图表';

-- ----------------------------
-- Records of init_advert
-- ----------------------------
BEGIN;
INSERT INTO `init_advert` VALUES (3, '祥云分店', 'http://syb.ruipengwang.com:8082/syb_admin/download/images/gytyy.jpg', 1, 'http://www.xiaoertuina.net/', 0, NULL, NULL, 0, 0, 1, '2018-03-02 10:55:45');
INSERT INTO `init_advert` VALUES (4, '石园分部', 'http://syb.ruipengwang.com:8082/syb_admin/download/images/shiyuan.jpg', 2, 'http://www.xiaoertuina.net/', 0, NULL, NULL, 0, 0, 1, '2018-03-02 10:55:45');
INSERT INTO `init_advert` VALUES (5, '特大喜讯，小儿推拿即将与2月3号开启专家门诊。特大喜讯，小儿推拿即将与2月3号开', 'http://syb.ruipengwang.com:8082/syb_admin/download/images/gytyy.jpg', 4, 'http://www.xiaoertuina.net/12', 0, NULL, NULL, 1, 0, 1, '2018-03-02 10:55:45');
INSERT INTO `init_advert` VALUES (8, '特大消息，我不知道你说的是什么，明天广播', NULL, NULL, 'http://www.xiaoertuina.net/1', 0, NULL, NULL, 1, 0, 1, '2018-03-22 15:10:29');
INSERT INTO `init_advert` VALUES (10, NULL, 'http://syb.ruipengwang.com:8082/syb_admin/download/images/gytyy.jpg', 4, 'http://www.xiaoertuina.net/', 0, NULL, NULL, 0, 0, 1, '2018-03-28 10:15:10');
INSERT INTO `init_advert` VALUES (27, '特大喜讯，小儿推拿即将与2月3号开启专家门诊。特大喜讯，小儿推拿即将与2月3号开', NULL, NULL, 'http://www.xiaoertuina.ne', 0, NULL, NULL, 1, 0, NULL, '2018-04-01 19:03:25');
INSERT INTO `init_advert` VALUES (28, NULL, 'http://47.92.39.186:80/image/image_tmp/20180403090421_7611.jpg', NULL, 'http://www.xiaoertuina.net/', 0, NULL, NULL, 0, 20, NULL, '2018-04-02 14:39:06');
INSERT INTO `init_advert` VALUES (29, NULL, 'http://47.92.39.186:80/image/image_tmp/20180403090532_4572.jpg', NULL, 'http://www.xiaoertuina.net/', 0, NULL, NULL, 0, 20, NULL, '2018-04-02 19:40:15');
INSERT INTO `init_advert` VALUES (30, NULL, 'http://47.92.39.186:80/image/image_tmp/20180426151825_7325.jpg', NULL, 'http://localhost:8080/xrtn-manager/ad/gotoInit6', 0, NULL, NULL, 0, 0, NULL, '2018-04-26 15:18:38');
INSERT INTO `init_advert` VALUES (31, NULL, 'http://47.92.39.186:80/image/image_tmp/20180426151831_99.png', NULL, 'http://localhost:8080/xrtn-manager/ad/gotoInit', 0, NULL, NULL, 0, 1, NULL, '2018-04-26 15:18:40');
INSERT INTO `init_advert` VALUES (32, NULL, 'http://47.92.39.186:80/image/image_tmp/20180426151835_4778.jpg', NULL, 'http://localhost:8080/xrtn-manager/ad/gotoInit', 0, NULL, NULL, 0, 1, NULL, '2018-04-26 15:18:42');
INSERT INTO `init_advert` VALUES (33, '123656', NULL, NULL, '1233655585', 0, NULL, NULL, 1, 0, NULL, '2018-04-26 15:21:57');
INSERT INTO `init_advert` VALUES (34, '1236548989556456', NULL, NULL, '556959', 0, NULL, NULL, 1, 3, NULL, '2018-04-26 15:27:30');
INSERT INTO `init_advert` VALUES (35, '123456654654', NULL, NULL, '45645641', 0, NULL, NULL, 1, 3, NULL, '2018-04-26 16:24:36');
INSERT INTO `init_advert` VALUES (36, NULL, 'http://47.92.39.186:80/image/image_tmp/20180426162507_5833.jpg', NULL, '123456', 0, NULL, NULL, 0, 1, NULL, '2018-04-26 16:25:02');
INSERT INTO `init_advert` VALUES (37, '1', NULL, NULL, '11', 0, NULL, NULL, 1, 3, NULL, '2018-04-26 18:58:08');
INSERT INTO `init_advert` VALUES (38, '111', NULL, NULL, '111', 0, NULL, NULL, 1, 3, NULL, '2018-04-26 19:00:31');
COMMIT;

-- ----------------------------
-- Table structure for init_conclusion_info
-- ----------------------------
DROP TABLE IF EXISTS `init_conclusion_info`;
CREATE TABLE `init_conclusion_info` (
  `conclusion_id` int(11) NOT NULL AUTO_INCREMENT,
  `conclusion_name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`conclusion_id`)
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='诊断结论表';

-- ----------------------------
-- Records of init_conclusion_info
-- ----------------------------
BEGIN;
INSERT INTO `init_conclusion_info` VALUES (1, '风寒束表');
INSERT INTO `init_conclusion_info` VALUES (2, '风热犯表');
INSERT INTO `init_conclusion_info` VALUES (3, '暑湿袭表');
INSERT INTO `init_conclusion_info` VALUES (4, '风寒袭肺');
INSERT INTO `init_conclusion_info` VALUES (5, '风热犯肺');
INSERT INTO `init_conclusion_info` VALUES (6, '痰热壅肺');
INSERT INTO `init_conclusion_info` VALUES (7, '痰湿蕴肺');
INSERT INTO `init_conclusion_info` VALUES (8, '寒饮停肺');
INSERT INTO `init_conclusion_info` VALUES (9, '肺气亏虚');
INSERT INTO `init_conclusion_info` VALUES (10, '肺阴亏虚');
INSERT INTO `init_conclusion_info` VALUES (11, '脾气亏虚');
INSERT INTO `init_conclusion_info` VALUES (12, '肾气亏虚');
INSERT INTO `init_conclusion_info` VALUES (13, '肺热阴虚');
INSERT INTO `init_conclusion_info` VALUES (14, '肺脾气虚');
INSERT INTO `init_conclusion_info` VALUES (15, '心脾积热');
INSERT INTO `init_conclusion_info` VALUES (16, '伤食泻');
INSERT INTO `init_conclusion_info` VALUES (17, '风寒泻');
INSERT INTO `init_conclusion_info` VALUES (18, '湿热泻');
INSERT INTO `init_conclusion_info` VALUES (19, '寒湿泻');
INSERT INTO `init_conclusion_info` VALUES (20, '脾虚泻');
INSERT INTO `init_conclusion_info` VALUES (21, '脾胃不和');
INSERT INTO `init_conclusion_info` VALUES (22, '脾胃气虚');
INSERT INTO `init_conclusion_info` VALUES (23, '脾胃阴虚');
INSERT INTO `init_conclusion_info` VALUES (24, '脾胃阴虚');
INSERT INTO `init_conclusion_info` VALUES (25, '脾肾阳虚');
INSERT INTO `init_conclusion_info` VALUES (26, '湿困脾胃');
INSERT INTO `init_conclusion_info` VALUES (27, '乳食内积');
INSERT INTO `init_conclusion_info` VALUES (28, '脾虚夹积');
INSERT INTO `init_conclusion_info` VALUES (29, '心脾两虚');
INSERT INTO `init_conclusion_info` VALUES (30, '心经积热');
INSERT INTO `init_conclusion_info` VALUES (31, '肝肾阴虚');
INSERT INTO `init_conclusion_info` VALUES (32, '肾虚肝亢');
INSERT INTO `init_conclusion_info` VALUES (33, '脾虚肝旺');
INSERT INTO `init_conclusion_info` VALUES (34, '肺热血瘀');
COMMIT;

-- ----------------------------
-- Table structure for init_disease_info
-- ----------------------------
DROP TABLE IF EXISTS `init_disease_info`;
CREATE TABLE `init_disease_info` (
  `desc_id` int(11) NOT NULL AUTO_INCREMENT,
  `type_id` int(11) DEFAULT NULL COMMENT '类型',
  `desc_name` varchar(300) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '描述',
  `disease_score` int(2) DEFAULT '0' COMMENT '得分值',
  PRIMARY KEY (`desc_id`)
) ENGINE=InnoDB AUTO_INCREMENT=225 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='病症程度信息表';

-- ----------------------------
-- Records of init_disease_info
-- ----------------------------
BEGIN;
INSERT INTO `init_disease_info` VALUES (19, 8, '无', 10);
INSERT INTO `init_disease_info` VALUES (20, 8, '每天1-4个', 8);
INSERT INTO `init_disease_info` VALUES (21, 8, '每天5-8个', 6);
INSERT INTO `init_disease_info` VALUES (22, 8, '每天9-12个', 4);
INSERT INTO `init_disease_info` VALUES (23, 8, '每天13-15个', 2);
INSERT INTO `init_disease_info` VALUES (24, 8, '每天15个以上', 0);
INSERT INTO `init_disease_info` VALUES (25, 17, '1天-3天', 0);
INSERT INTO `init_disease_info` VALUES (26, 17, '4-7天', 0);
INSERT INTO `init_disease_info` VALUES (27, 17, '8-14天', 0);
INSERT INTO `init_disease_info` VALUES (28, 17, '15到30天', 0);
INSERT INTO `init_disease_info` VALUES (29, 17, '1个月-2个月', 0);
INSERT INTO `init_disease_info` VALUES (30, 17, '2个月到3月', 0);
INSERT INTO `init_disease_info` VALUES (31, 18, '非常活泼', 0);
INSERT INTO `init_disease_info` VALUES (32, 18, '正常', 0);
INSERT INTO `init_disease_info` VALUES (33, 18, '轻微萎靡', 0);
INSERT INTO `init_disease_info` VALUES (34, 18, '中等萎靡', 0);
INSERT INTO `init_disease_info` VALUES (35, 18, '严重萎靡', 0);
INSERT INTO `init_disease_info` VALUES (36, 19, '正常', 0);
INSERT INTO `init_disease_info` VALUES (37, 19, '瘦', 0);
INSERT INTO `init_disease_info` VALUES (38, 19, '胖', 0);
INSERT INTO `init_disease_info` VALUES (39, 19, '营养不良', 0);
INSERT INTO `init_disease_info` VALUES (40, 19, '超重20斤以上', 0);
INSERT INTO `init_disease_info` VALUES (41, 20, '正常', 0);
INSERT INTO `init_disease_info` VALUES (42, 20, '黄', 0);
INSERT INTO `init_disease_info` VALUES (43, 20, '青', 0);
INSERT INTO `init_disease_info` VALUES (44, 20, '白', 0);
INSERT INTO `init_disease_info` VALUES (45, 20, '红', 0);
INSERT INTO `init_disease_info` VALUES (46, 20, '黑', 0);
INSERT INTO `init_disease_info` VALUES (47, 21, '淡', 0);
INSERT INTO `init_disease_info` VALUES (48, 21, '粉', 0);
INSERT INTO `init_disease_info` VALUES (49, 21, '全红', 0);
INSERT INTO `init_disease_info` VALUES (50, 21, '绛紫', 0);
INSERT INTO `init_disease_info` VALUES (51, 21, '有红芒刺', 0);
INSERT INTO `init_disease_info` VALUES (52, 21, '舌尖红', 0);
INSERT INTO `init_disease_info` VALUES (53, 21, '看不到舌质', 0);
INSERT INTO `init_disease_info` VALUES (54, 22, '薄白', 0);
INSERT INTO `init_disease_info` VALUES (55, 22, '薄黄', 0);
INSERT INTO `init_disease_info` VALUES (56, 22, '白厚腻', 0);
INSERT INTO `init_disease_info` VALUES (57, 22, '黄厚腻', 0);
INSERT INTO `init_disease_info` VALUES (58, 22, '裂纹', 0);
INSERT INTO `init_disease_info` VALUES (59, 22, '剥落', 0);
INSERT INTO `init_disease_info` VALUES (60, 22, '地图', 0);
INSERT INTO `init_disease_info` VALUES (61, 22, '无苔', 0);
INSERT INTO `init_disease_info` VALUES (62, 22, '湿腻', 0);
INSERT INTO `init_disease_info` VALUES (63, 23, '正常', 0);
INSERT INTO `init_disease_info` VALUES (64, 23, '白天微微自汗', 0);
INSERT INTO `init_disease_info` VALUES (65, 23, '稍一运动有汗', 0);
INSERT INTO `init_disease_info` VALUES (66, 23, '白天频繁自汗', 0);
INSERT INTO `init_disease_info` VALUES (67, 23, '夜晚睡着后1-2小时内汗多', 0);
INSERT INTO `init_disease_info` VALUES (68, 23, '夜晚睡着后盗汗', 0);
INSERT INTO `init_disease_info` VALUES (69, 24, '正常', 0);
INSERT INTO `init_disease_info` VALUES (70, 24, '偶尔早上起床有', 0);
INSERT INTO `init_disease_info` VALUES (71, 24, '近期总是有点味道', 0);
INSERT INTO `init_disease_info` VALUES (72, 24, '味道比较重', 0);
INSERT INTO `init_disease_info` VALUES (73, 24, '味道很重', 0);
INSERT INTO `init_disease_info` VALUES (74, 25, '正常', 0);
INSERT INTO `init_disease_info` VALUES (75, 25, '微微有热，有汗', 0);
INSERT INTO `init_disease_info` VALUES (76, 25, '有点热，有汗', 0);
INSERT INTO `init_disease_info` VALUES (77, 25, '比较热，无汗', 0);
INSERT INTO `init_disease_info` VALUES (78, 25, '很热，干', 0);
INSERT INTO `init_disease_info` VALUES (79, 25, '非常热，干', 0);
INSERT INTO `init_disease_info` VALUES (80, 26, '正常', 0);
INSERT INTO `init_disease_info` VALUES (81, 26, '微红不肿', 0);
INSERT INTO `init_disease_info` VALUES (82, 26, '不痛', 0);
INSERT INTO `init_disease_info` VALUES (83, 26, '有点红，微肿1度', 0);
INSERT INTO `init_disease_info` VALUES (84, 26, '有点痛', 0);
INSERT INTO `init_disease_info` VALUES (85, 26, '有些红，肿大2度', 0);
INSERT INTO `init_disease_info` VALUES (86, 26, '有些痛', 0);
INSERT INTO `init_disease_info` VALUES (87, 26, '很红，肿大3度', 0);
INSERT INTO `init_disease_info` VALUES (88, 26, '很痛', 0);
INSERT INTO `init_disease_info` VALUES (89, 26, '非常红，肿大4度', 0);
INSERT INTO `init_disease_info` VALUES (90, 26, '非常痛', 0);
INSERT INTO `init_disease_info` VALUES (91, 27, '正常', 0);
INSERT INTO `init_disease_info` VALUES (92, 27, '微红不肿', 0);
INSERT INTO `init_disease_info` VALUES (93, 27, '有些红', 0);
INSERT INTO `init_disease_info` VALUES (94, 27, '很红', 0);
INSERT INTO `init_disease_info` VALUES (95, 27, '肿堵塞4分之1', 0);
INSERT INTO `init_disease_info` VALUES (96, 27, '有些肿堵塞3分之1', 0);
INSERT INTO `init_disease_info` VALUES (97, 27, '肿/堵塞2分之1', 0);
INSERT INTO `init_disease_info` VALUES (98, 27, '肿/堵塞4分之3以上', 0);
INSERT INTO `init_disease_info` VALUES (99, 27, '有粘膜破损', 0);
INSERT INTO `init_disease_info` VALUES (100, 28, '白', 0);
INSERT INTO `init_disease_info` VALUES (101, 28, '清', 0);
INSERT INTO `init_disease_info` VALUES (102, 28, '黄', 0);
INSERT INTO `init_disease_info` VALUES (103, 28, '稠', 0);
INSERT INTO `init_disease_info` VALUES (104, 28, '粘', 0);
INSERT INTO `init_disease_info` VALUES (105, 28, '干', 0);
INSERT INTO `init_disease_info` VALUES (106, 29, '晨起', 0);
INSERT INTO `init_disease_info` VALUES (107, 29, '运动时', 0);
INSERT INTO `init_disease_info` VALUES (108, 29, '大声喊叫时', 0);
INSERT INTO `init_disease_info` VALUES (109, 29, '白天', 0);
INSERT INTO `init_disease_info` VALUES (110, 29, '睡前', 0);
INSERT INTO `init_disease_info` VALUES (111, 29, '刚入睡时', 0);
INSERT INTO `init_disease_info` VALUES (112, 29, '前半夜', 0);
INSERT INTO `init_disease_info` VALUES (113, 29, '后半夜', 0);
INSERT INTO `init_disease_info` VALUES (114, 30, '多痰', 0);
INSERT INTO `init_disease_info` VALUES (115, 30, '少痰', 0);
INSERT INTO `init_disease_info` VALUES (116, 30, '无痰', 0);
INSERT INTO `init_disease_info` VALUES (117, 30, '痰白粘', 0);
INSERT INTO `init_disease_info` VALUES (118, 30, '痰清稀', 0);
INSERT INTO `init_disease_info` VALUES (119, 30, '痰黄', 0);
INSERT INTO `init_disease_info` VALUES (120, 31, '稀', 0);
INSERT INTO `init_disease_info` VALUES (121, 31, '有泡沫', 0);
INSERT INTO `init_disease_info` VALUES (122, 31, '蛋花状', 0);
INSERT INTO `init_disease_info` VALUES (123, 31, '有未消化的食物残渣', 0);
INSERT INTO `init_disease_info` VALUES (124, 31, '清水样便', 0);
INSERT INTO `init_disease_info` VALUES (125, 31, '黄', 0);
INSERT INTO `init_disease_info` VALUES (126, 32, '不硬，软便', 0);
INSERT INTO `init_disease_info` VALUES (127, 32, '全干，粗', 0);
INSERT INTO `init_disease_info` VALUES (128, 32, '前干，粗', 0);
INSERT INTO `init_disease_info` VALUES (129, 32, '后稀', 0);
INSERT INTO `init_disease_info` VALUES (130, 32, '前羊粪蛋', 0);
INSERT INTO `init_disease_info` VALUES (131, 32, '全羊粪蛋', 0);
INSERT INTO `init_disease_info` VALUES (132, 32, '色黑', 0);
INSERT INTO `init_disease_info` VALUES (133, 32, '色黄', 0);
INSERT INTO `init_disease_info` VALUES (134, 1, '无', 10);
INSERT INTO `init_disease_info` VALUES (135, 1, '有时 有一口痰呼噜呼噜在咽喉部 ', 8);
INSERT INTO `init_disease_info` VALUES (136, 1, '咽喉部，干咳 偶尔 ，不定时', 6);
INSERT INTO `init_disease_info` VALUES (137, 1, ' 有时在气管部位 咳声粗重，较费力', 4);
INSERT INTO `init_disease_info` VALUES (138, 1, '经常，频率很高 □肺部深咳，费力    ', 2);
INSERT INTO `init_disease_info` VALUES (139, 1, '咳嗽几乎不停，无法入睡，呕吐在肺部深咳，费力', 0);
INSERT INTO `init_disease_info` VALUES (140, 2, '无', 10);
INSERT INTO `init_disease_info` VALUES (141, 2, '37度2-37度5', 8);
INSERT INTO `init_disease_info` VALUES (142, 2, '37度6-38度4', 6);
INSERT INTO `init_disease_info` VALUES (143, 2, '38度5到39度', 4);
INSERT INTO `init_disease_info` VALUES (144, 2, '39度1到40度', 2);
INSERT INTO `init_disease_info` VALUES (145, 2, '40度以上', 0);
INSERT INTO `init_disease_info` VALUES (146, 3, '无', 10);
INSERT INTO `init_disease_info` VALUES (147, 3, '一侧微微有脓点', 8);
INSERT INTO `init_disease_info` VALUES (148, 3, '一侧有一些脓点', 6);
INSERT INTO `init_disease_info` VALUES (149, 3, '两侧都有些脓点', 4);
INSERT INTO `init_disease_info` VALUES (150, 3, '两侧都有很多脓点', 2);
INSERT INTO `init_disease_info` VALUES (151, 3, '全部化脓，成片状', 0);
INSERT INTO `init_disease_info` VALUES (152, 4, '无', 10);
INSERT INTO `init_disease_info` VALUES (153, 4, '□1度（微微超过咽腭弓） ', 8);
INSERT INTO `init_disease_info` VALUES (154, 4, '□2度（肿大到中线，超过咽腭弓）', 6);
INSERT INTO `init_disease_info` VALUES (155, 4, '3度 （超过咽腭弓，肿大超过中线）', 4);
INSERT INTO `init_disease_info` VALUES (156, 4, '4度（双侧只剩下一条缝隙）', 2);
INSERT INTO `init_disease_info` VALUES (157, 4, '全部堵塞，吐字不清', 0);
INSERT INTO `init_disease_info` VALUES (158, 5, '无', 10);
INSERT INTO `init_disease_info` VALUES (159, 5, '轻微堵塞', 8);
INSERT INTO `init_disease_info` VALUES (160, 5, '轻度堵塞', 6);
INSERT INTO `init_disease_info` VALUES (161, 5, '中度堵塞，影响呼吸和说话', 4);
INSERT INTO `init_disease_info` VALUES (162, 5, '重度堵塞，影响睡眠或无专注力', 2);
INSERT INTO `init_disease_info` VALUES (163, 5, '非常严重堵塞，存在呼吸暂停', 0);
INSERT INTO `init_disease_info` VALUES (164, 6, '无', 10);
INSERT INTO `init_disease_info` VALUES (165, 6, '□少量', 8);
INSERT INTO `init_disease_info` VALUES (166, 6, '□不多偶尔', 6);
INSERT INTO `init_disease_info` VALUES (167, 6, '□比较多', 4);
INSERT INTO `init_disease_info` VALUES (168, 6, '□很多', 2);
INSERT INTO `init_disease_info` VALUES (169, 6, '□非常多', 0);
INSERT INTO `init_disease_info` VALUES (170, 7, '无', 10);
INSERT INTO `init_disease_info` VALUES (171, 7, '轻微', 8);
INSERT INTO `init_disease_info` VALUES (172, 7, '偶尔', 6);
INSERT INTO `init_disease_info` VALUES (173, 7, '经常', 4);
INSERT INTO `init_disease_info` VALUES (174, 7, '严重', 2);
INSERT INTO `init_disease_info` VALUES (175, 7, '用嘴呼吸', 0);
INSERT INTO `init_disease_info` VALUES (177, 9, '无', 10);
INSERT INTO `init_disease_info` VALUES (178, 9, '1天1-2次', 8);
INSERT INTO `init_disease_info` VALUES (179, 9, '1天3次', 6);
INSERT INTO `init_disease_info` VALUES (180, 9, '1天4次', 4);
INSERT INTO `init_disease_info` VALUES (181, 9, '1天5次', 2);
INSERT INTO `init_disease_info` VALUES (182, 9, '1天6次/    次', 0);
INSERT INTO `init_disease_info` VALUES (183, 10, '无', 10);
INSERT INTO `init_disease_info` VALUES (184, 10, '15天-15天以上1次或1次以上', 8);
INSERT INTO `init_disease_info` VALUES (185, 10, '10天以下1次或1次以上', 6);
INSERT INTO `init_disease_info` VALUES (186, 10, '5天以下1次或1次以上', 4);
INSERT INTO `init_disease_info` VALUES (187, 10, '3天以下1次或1次以上', 2);
INSERT INTO `init_disease_info` VALUES (188, 10, '2天及2天以下1次或1次以上', 0);
INSERT INTO `init_disease_info` VALUES (189, 15, '正常', 10);
INSERT INTO `init_disease_info` VALUES (190, 15, '饭量大，不挑食', 8);
INSERT INTO `init_disease_info` VALUES (191, 15, '偶尔挑食，饭量尚可', 6);
INSERT INTO `init_disease_info` VALUES (192, 15, '有些挑食，饭量一般', 4);
INSERT INTO `init_disease_info` VALUES (193, 15, '非常挑食，饭量小', 2);
INSERT INTO `init_disease_info` VALUES (194, 15, '基本没有食欲，饭量很小', 0);
INSERT INTO `init_disease_info` VALUES (195, 16, '正常', 10);
INSERT INTO `init_disease_info` VALUES (196, 16, '偶尔睡觉不安稳', 8);
INSERT INTO `init_disease_info` VALUES (197, 16, '有时晚上哭闹，醒1-2次，', 6);
INSERT INTO `init_disease_info` VALUES (198, 16, '有时夜间哭闹，醒3-4次', 4);
INSERT INTO `init_disease_info` VALUES (199, 16, '夜间醒5-6次', 2);
INSERT INTO `init_disease_info` VALUES (200, 16, '整夜哭闹，无法入睡', 0);
INSERT INTO `init_disease_info` VALUES (201, 14, '1天1次，性状正常', 10);
INSERT INTO `init_disease_info` VALUES (202, 14, '2天1次          □不硬，软便               ', 8);
INSERT INTO `init_disease_info` VALUES (203, 14, '3天1次            □不硬，软便    ', 6);
INSERT INTO `init_disease_info` VALUES (204, 14, '4天1次，         □不硬，软便 ', 4);
INSERT INTO `init_disease_info` VALUES (205, 14, '5天1次，□不硬，软便', 2);
INSERT INTO `init_disease_info` VALUES (206, 14, '6天/     天1次/□不硬，软便', 0);
INSERT INTO `init_disease_info` VALUES (207, 13, '1天1次，性状正常', 10);
INSERT INTO `init_disease_info` VALUES (208, 13, '2天1次           □性状稍硬        ', 8);
INSERT INTO `init_disease_info` VALUES (209, 13, '3天1次           □性状偏硬，干结           ', 6);
INSERT INTO `init_disease_info` VALUES (210, 13, '4天1次，         □性状很硬                 ', 4);
INSERT INTO `init_disease_info` VALUES (211, 13, '5天1次          □性状非常硬           ', 2);
INSERT INTO `init_disease_info` VALUES (212, 13, '6天/     天1次/□非常难排，肛裂，非常干粗       ', 0);
INSERT INTO `init_disease_info` VALUES (213, 12, '无，腹部软，绵', 10);
INSERT INTO `init_disease_info` VALUES (214, 12, '腹部微胀，微硬', 8);
INSERT INTO `init_disease_info` VALUES (215, 12, '腹部有点胀，有点硬', 6);
INSERT INTO `init_disease_info` VALUES (216, 12, '腹部比较胀，比较硬', 4);
INSERT INTO `init_disease_info` VALUES (217, 12, '腹部很胀，很硬，', 2);
INSERT INTO `init_disease_info` VALUES (218, 12, '腹部非常胀，非常硬', 0);
INSERT INTO `init_disease_info` VALUES (219, 11, '无', 10);
INSERT INTO `init_disease_info` VALUES (220, 11, '1天1-2次          ', 8);
INSERT INTO `init_disease_info` VALUES (221, 11, '1天3-5次           ', 6);
INSERT INTO `init_disease_info` VALUES (222, 11, '1天6-8次           ', 4);
INSERT INTO `init_disease_info` VALUES (223, 11, '1天9-10次               ', 2);
INSERT INTO `init_disease_info` VALUES (224, 11, '1天10次以上         ', 0);
COMMIT;

-- ----------------------------
-- Table structure for init_disease_type
-- ----------------------------
DROP TABLE IF EXISTS `init_disease_type`;
CREATE TABLE `init_disease_type` (
  `type_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主症ID',
  `type_name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '主症名称',
  `type_status` int(1) DEFAULT NULL COMMENT '状态:0:下线;1:上线',
  `is_main` int(1) DEFAULT NULL COMMENT '是否主症:0:否;1:是',
  PRIMARY KEY (`type_id`)
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='主症分类信息表';

-- ----------------------------
-- Records of init_disease_type
-- ----------------------------
BEGIN;
INSERT INTO `init_disease_type` VALUES (1, '咳嗽', 1, 1);
INSERT INTO `init_disease_type` VALUES (2, '发烧', 1, 1);
INSERT INTO `init_disease_type` VALUES (3, '扁桃体炎', 1, 1);
INSERT INTO `init_disease_type` VALUES (4, '扁桃体肥大', 1, 1);
INSERT INTO `init_disease_type` VALUES (5, '腺样体', 1, 1);
INSERT INTO `init_disease_type` VALUES (6, '鼻涕', 1, 1);
INSERT INTO `init_disease_type` VALUES (7, '鼻塞', 1, 1);
INSERT INTO `init_disease_type` VALUES (8, '打喷嚏', 1, 1);
INSERT INTO `init_disease_type` VALUES (9, '呕吐', 1, 1);
INSERT INTO `init_disease_type` VALUES (10, '腹痛', 1, 1);
INSERT INTO `init_disease_type` VALUES (11, '腹泻', 1, 1);
INSERT INTO `init_disease_type` VALUES (12, '腹胀', 1, 1);
INSERT INTO `init_disease_type` VALUES (13, '便秘实', 1, 1);
INSERT INTO `init_disease_type` VALUES (14, '便秘虚', 1, 1);
INSERT INTO `init_disease_type` VALUES (15, '食欲', 1, 1);
INSERT INTO `init_disease_type` VALUES (16, '睡眠', 1, 1);
INSERT INTO `init_disease_type` VALUES (17, '病程持续时间', 1, 0);
INSERT INTO `init_disease_type` VALUES (18, '精神状态', 1, 0);
INSERT INTO `init_disease_type` VALUES (19, '体态', 1, 0);
INSERT INTO `init_disease_type` VALUES (20, '面色', 1, 0);
INSERT INTO `init_disease_type` VALUES (21, '舌质', 1, 0);
INSERT INTO `init_disease_type` VALUES (22, '舌苔', 1, 0);
INSERT INTO `init_disease_type` VALUES (23, '出汗', 1, 0);
INSERT INTO `init_disease_type` VALUES (24, '口气', 1, 0);
INSERT INTO `init_disease_type` VALUES (25, '手脚心温度', 1, 0);
INSERT INTO `init_disease_type` VALUES (26, '扁桃体', 1, 0);
INSERT INTO `init_disease_type` VALUES (27, '鼻腔和鼻甲', 1, 0);
INSERT INTO `init_disease_type` VALUES (28, '鼻涕', 1, 0);
INSERT INTO `init_disease_type` VALUES (29, '咳嗽时间段', 1, 0);
INSERT INTO `init_disease_type` VALUES (30, '咳嗽痰性状和数量', 1, 0);
INSERT INTO `init_disease_type` VALUES (31, '腹泻排便性状和颜色', 1, 0);
INSERT INTO `init_disease_type` VALUES (32, '便秘排便性状和颜色', 1, 0);
COMMIT;

-- ----------------------------
-- Table structure for init_from_info
-- ----------------------------
DROP TABLE IF EXISTS `init_from_info`;
CREATE TABLE `init_from_info` (
  `from_id` int(11) NOT NULL AUTO_INCREMENT,
  `from_name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`from_id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='用户来源';

-- ----------------------------
-- Records of init_from_info
-- ----------------------------
BEGIN;
INSERT INTO `init_from_info` VALUES (1, '门店');
INSERT INTO `init_from_info` VALUES (2, '微信');
INSERT INTO `init_from_info` VALUES (3, '朋友介绍');
INSERT INTO `init_from_info` VALUES (4, '宣传单');
INSERT INTO `init_from_info` VALUES (5, '住附近');
INSERT INTO `init_from_info` VALUES (6, '团购');
INSERT INTO `init_from_info` VALUES (7, '其他');
COMMIT;

-- ----------------------------
-- Table structure for init_goods_info
-- ----------------------------
DROP TABLE IF EXISTS `init_goods_info`;
CREATE TABLE `init_goods_info` (
  `goods_id` int(11) NOT NULL AUTO_INCREMENT,
  `type_id` int(11) DEFAULT NULL COMMENT '分类',
  `goods_name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '名称',
  `goods_label` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '标签',
  `goods_img` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '图片',
  `goods_cost` decimal(6,2) DEFAULT '0.00' COMMENT '售价',
  `goods_income_ratio` decimal(6,2) DEFAULT '0.10' COMMENT '提成比率',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP,
  `goods_state` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT '0' COMMENT '商品状态：0下架；1上架',
  PRIMARY KEY (`goods_id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='商品信息表';

-- ----------------------------
-- Records of init_goods_info
-- ----------------------------
BEGIN;
INSERT INTO `init_goods_info` VALUES (2, NULL, '咳嗽-药膏', NULL, 'https://ss3.bdstatic.com/70cFv8Sh_Q1YnxGkpoWK1HF6hhy/it/u=4203775604,2360667065&fm=27&gp=0.jpg', 79.00, 0.10, '2018-03-01 17:06:48', '1');
INSERT INTO `init_goods_info` VALUES (3, NULL, '感冒-药膏', NULL, 'https://ss1.bdstatic.com/70cFvXSh_Q1YnxGkpoWK1HF6hhy/it/u=3422469595,3583368358&fm=27&gp=0.jpg', 99.00, 0.10, '2018-03-01 17:06:50', '1');
INSERT INTO `init_goods_info` VALUES (4, NULL, '碘伏', NULL, 'https://ss1.baidu.com/6ONXsjip0QIZ8tyhnq/it/u=754839334,508408320&fm=58', 12.00, 0.10, '2018-03-15 09:41:11', '0');
INSERT INTO `init_goods_info` VALUES (5, NULL, '棉签', NULL, 'https://ss3.baidu.com/-rVXeDTa2gU2pMbgoY3K/it/u=3842892841,3686233537&fm=202&src=764&mola=new&crop=v', 3.00, 0.10, '2018-03-15 09:41:21', '0');
INSERT INTO `init_goods_info` VALUES (6, NULL, '胶布', NULL, 'https://ss3.baidu.com/-rVXeDTa2gU2pMbgoY3K/it/u=2335535491,2741577766&fm=202&src=764&mola=new&crop=v', 3.00, 0.10, '2018-03-15 09:41:24', '1');
INSERT INTO `init_goods_info` VALUES (7, NULL, '纱布', NULL, 'https://ss3.baidu.com/-rVXeDTa2gU2pMbgoY3K/it/u=3698985509,1707831479&fm=202&mola=new&crop=v1', 6.00, 0.10, '2018-03-15 09:41:39', '0');
INSERT INTO `init_goods_info` VALUES (8, NULL, '创可贴', NULL, 'https://ss0.baidu.com/73F1bjeh1BF3odCf/it/u=1124645592,4058646370&fm=85&s=8D26EC17114654EA1AFDA1DA02', 10.00, 0.10, '2018-03-15 09:41:43', '0');
COMMIT;

-- ----------------------------
-- Table structure for init_goods_type
-- ----------------------------
DROP TABLE IF EXISTS `init_goods_type`;
CREATE TABLE `init_goods_type` (
  `type_id` int(11) NOT NULL AUTO_INCREMENT,
  `type_name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='商品类别信息表';

-- ----------------------------
-- Table structure for init_grade_doctor
-- ----------------------------
DROP TABLE IF EXISTS `init_grade_doctor`;
CREATE TABLE `init_grade_doctor` (
  `grade_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '医生等级表主键ID',
  `grade_name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '等级名称:示例 实习医生',
  `grade_img` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '等级img',
  `grade_start_score` int(4) DEFAULT '0' COMMENT '等级限制：起始值',
  `grade_end_score` int(4) DEFAULT '0' COMMENT '等级限制：结束值',
  `grade_number` int(11) DEFAULT '1' COMMENT '当前级别',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `reply_ratio` int(3) DEFAULT NULL COMMENT '满意度',
  `complain_ratio` int(3) DEFAULT NULL COMMENT '投诉率',
  `month_treatment_ratio` int(3) DEFAULT NULL COMMENT '月治愈率',
  PRIMARY KEY (`grade_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='医生等级设置';

-- ----------------------------
-- Records of init_grade_doctor
-- ----------------------------
BEGIN;
INSERT INTO `init_grade_doctor` VALUES (1, '一星员工', NULL, 0, 100, 1, '2018-02-27 10:03:02', 90, 0, 80);
INSERT INTO `init_grade_doctor` VALUES (2, '二星员工', NULL, 101, 150, 2, '2018-03-02 09:32:53', 90, 0, 80);
INSERT INTO `init_grade_doctor` VALUES (3, '三星员工', NULL, 151, 200, 3, '2018-03-20 09:08:32', 90, 0, 80);
INSERT INTO `init_grade_doctor` VALUES (4, '四星员工', NULL, 201, 250, 4, '2018-03-20 09:08:42', 90, 0, 80);
INSERT INTO `init_grade_doctor` VALUES (5, '五星员工', NULL, 251, 300, 5, '2018-03-20 09:08:57', 90, 0, 80);
COMMIT;

-- ----------------------------
-- Table structure for init_grade_user
-- ----------------------------
DROP TABLE IF EXISTS `init_grade_user`;
CREATE TABLE `init_grade_user` (
  `grade_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '会员等级表主键ID',
  `grade_name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '等级名称:示例 初级会员',
  `grade_img` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '等级img',
  `grade_start_score` int(4) DEFAULT '0' COMMENT '等级限制：起始值',
  `grade_end_score` int(4) DEFAULT '0' COMMENT '等级限制：结束值',
  `grade_number` int(11) DEFAULT '1' COMMENT '当前级别',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`grade_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='会员等级设置';

-- ----------------------------
-- Records of init_grade_user
-- ----------------------------
BEGIN;
INSERT INTO `init_grade_user` VALUES (1, '初级会员', NULL, 0, 100, 1, '2018-02-28 14:22:05');
INSERT INTO `init_grade_user` VALUES (2, '中级会员', NULL, 101, 1000, 2, '2018-02-28 14:22:25');
COMMIT;

-- ----------------------------
-- Table structure for init_home_nursing_info
-- ----------------------------
DROP TABLE IF EXISTS `init_home_nursing_info`;
CREATE TABLE `init_home_nursing_info` (
  `nursing_id` int(11) NOT NULL AUTO_INCREMENT,
  `type_id` int(11) DEFAULT NULL,
  `nursing_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nursing_value` int(11) DEFAULT NULL,
  PRIMARY KEY (`nursing_id`)
) ENGINE=InnoDB AUTO_INCREMENT=121 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of init_home_nursing_info
-- ----------------------------
BEGIN;
INSERT INTO `init_home_nursing_info` VALUES (1, 1, '正常', 5);
INSERT INTO `init_home_nursing_info` VALUES (2, 1, '有一点偏食水果/辛辣/肉类', 4);
INSERT INTO `init_home_nursing_info` VALUES (3, 1, '有一些偏食水果/辛辣/肉类', 3);
INSERT INTO `init_home_nursing_info` VALUES (4, 1, '非常偏食水果/辛辣/肉类', 2);
INSERT INTO `init_home_nursing_info` VALUES (5, 1, '大量水果/辛辣/肉类', 1);
INSERT INTO `init_home_nursing_info` VALUES (6, 1, '极端水果/辛辣/肉类', 0);
INSERT INTO `init_home_nursing_info` VALUES (7, 2, '适龄足月顺产/剖腹', 5);
INSERT INTO `init_home_nursing_info` VALUES (8, 2, '高龄足月顺产/剖腹', 4);
INSERT INTO `init_home_nursing_info` VALUES (9, 2, '适龄/高龄剖腹早产7天之内', 3);
INSERT INTO `init_home_nursing_info` VALUES (10, 2, '适龄/高龄剖腹早产7-14天', 2);
INSERT INTO `init_home_nursing_info` VALUES (11, 2, '适龄/高龄剖腹早产14-21天', 1);
INSERT INTO `init_home_nursing_info` VALUES (12, 2, '适龄/高龄剖腹早产21天到         天', 0);
INSERT INTO `init_home_nursing_info` VALUES (13, 3, '正常', 5);
INSERT INTO `init_home_nursing_info` VALUES (14, 3, '父母双方中有一方幼儿时瘦小，胃口差', 4);
INSERT INTO `init_home_nursing_info` VALUES (15, 3, '父母双方幼儿时都瘦小，胃口差', 3);
INSERT INTO `init_home_nursing_info` VALUES (16, 3, '父母双方中有一方幼儿时多病', 2);
INSERT INTO `init_home_nursing_info` VALUES (17, 3, '父母双方中幼儿时都多病', 1);
INSERT INTO `init_home_nursing_info` VALUES (18, 3, '父母双方幼儿时都多病，瘦，矮，胃口差', 0);
INSERT INTO `init_home_nursing_info` VALUES (19, 4, '纯母乳12个月以上               +奶粉   月', 5);
INSERT INTO `init_home_nursing_info` VALUES (20, 4, '纯母乳9-11个月   +奶粉   月', 4);
INSERT INTO `init_home_nursing_info` VALUES (21, 4, '纯母乳6-10个月    +奶粉   月', 3);
INSERT INTO `init_home_nursing_info` VALUES (22, 4, '纯母乳3-6月       +奶粉   月', 2);
INSERT INTO `init_home_nursing_info` VALUES (23, 4, '纯母乳1-3月     +奶粉   月', 1);
INSERT INTO `init_home_nursing_info` VALUES (24, 4, '无母乳，       纯奶粉   月', 0);
INSERT INTO `init_home_nursing_info` VALUES (25, 5, '家庭成员无湿疹，无过敏性鼻炎，无咽炎，无过敏性咳嗽，无过敏源。无其他过敏性病。', 5);
INSERT INTO `init_home_nursing_info` VALUES (26, 5, '家庭成员有过敏性咳嗽，无过敏性鼻炎，无咽炎，无湿疹，无过敏源。无其他过敏性病', 4);
INSERT INTO `init_home_nursing_info` VALUES (27, 5, '家庭成员有过敏性咳嗽，有过敏性鼻炎，无咽炎，无湿疹，无过敏源。无其他过敏性病', 3);
INSERT INTO `init_home_nursing_info` VALUES (28, 5, '家庭成员有过敏性咳嗽，有过敏性鼻炎，有咽炎，无湿疹，无过敏源。无其他过敏性病', 2);
INSERT INTO `init_home_nursing_info` VALUES (29, 5, '家庭成员有过敏性咳嗽，有过敏性鼻炎，有咽炎，有湿疹，无过敏源。无其他过敏性病', 1);
INSERT INTO `init_home_nursing_info` VALUES (30, 5, '家庭成员有过敏性咳嗽，有过敏性鼻炎，有咽炎，有湿疹，有过敏源。有其他过敏性病', 0);
INSERT INTO `init_home_nursing_info` VALUES (31, 6, '1人  父亲/母亲/姥姥/姥爷/奶奶/爷爷/保姆/亲戚', 5);
INSERT INTO `init_home_nursing_info` VALUES (32, 6, '2人  父亲/母亲/姥姥/姥爷/奶奶/爷爷/保姆/亲戚', 4);
INSERT INTO `init_home_nursing_info` VALUES (33, 6, '3人  父亲/母亲/姥姥/姥爷/奶奶/爷爷/保姆/亲戚', 3);
INSERT INTO `init_home_nursing_info` VALUES (34, 6, '4人 父亲/母亲/姥姥/姥爷/奶奶/爷爷/保姆/亲戚', 2);
INSERT INTO `init_home_nursing_info` VALUES (35, 6, '5人  父亲/母亲/姥姥/姥爷/奶奶/爷爷/保姆/亲戚', 1);
INSERT INTO `init_home_nursing_info` VALUES (36, 6, '6人以上 父亲/母亲/姥姥/姥爷/奶奶/爷爷/保姆/亲戚', 0);
INSERT INTO `init_home_nursing_info` VALUES (37, 7, '可严格按要求忌口', 5);
INSERT INTO `init_home_nursing_info` VALUES (38, 7, '偶尔可以忌口', 4);
INSERT INTO `init_home_nursing_info` VALUES (39, 7, '有时可以忌口', 3);
INSERT INTO `init_home_nursing_info` VALUES (40, 7, '经常不能忌口', 2);
INSERT INTO `init_home_nursing_info` VALUES (41, 7, '总是不忌口', 1);
INSERT INTO `init_home_nursing_info` VALUES (42, 7, '完全不忌口', 0);
INSERT INTO `init_home_nursing_info` VALUES (43, 8, '基本不外出就餐', 5);
INSERT INTO `init_home_nursing_info` VALUES (44, 8, '偶尔', 4);
INSERT INTO `init_home_nursing_info` VALUES (45, 8, '有时', 3);
INSERT INTO `init_home_nursing_info` VALUES (46, 8, '经常', 2);
INSERT INTO `init_home_nursing_info` VALUES (47, 8, '总是在外用餐', 1);
INSERT INTO `init_home_nursing_info` VALUES (48, 8, '完全不在家吃饭', 0);
INSERT INTO `init_home_nursing_info` VALUES (49, 9, '基本不吃，量很少', 5);
INSERT INTO `init_home_nursing_info` VALUES (50, 9, '偶尔1天吃1次，约半个橙子大小', 4);
INSERT INTO `init_home_nursing_info` VALUES (51, 9, '有时一天2次，约1个橙子大小', 3);
INSERT INTO `init_home_nursing_info` VALUES (52, 9, '经常 一天3次,约2-3个橙子大小', 2);
INSERT INTO `init_home_nursing_info` VALUES (53, 9, '总是吃一天4次,约4-5个橙子大小', 1);
INSERT INTO `init_home_nursing_info` VALUES (54, 9, '很少吃饭，只吃水果/零食,只喝奶', 0);
INSERT INTO `init_home_nursing_info` VALUES (55, 10, '基本不吃，量很少', 5);
INSERT INTO `init_home_nursing_info` VALUES (56, 10, '偶尔1周吃1次，量很小', 4);
INSERT INTO `init_home_nursing_info` VALUES (57, 10, '有时3-4天1次，约2个乒乓球大小', 3);
INSERT INTO `init_home_nursing_info` VALUES (58, 10, '2-3天1次，约2个乒乓球大小', 2);
INSERT INTO `init_home_nursing_info` VALUES (59, 10, '1-2天1次，约3个乒乓球大小', 1);
INSERT INTO `init_home_nursing_info` VALUES (60, 10, '天天吃，超过3个乒乓球大小', 0);
INSERT INTO `init_home_nursing_info` VALUES (61, 11, '基本不喝，只吃母乳或正餐', 5);
INSERT INTO `init_home_nursing_info` VALUES (62, 11, '一天200毫升以内', 4);
INSERT INTO `init_home_nursing_info` VALUES (63, 11, '一天600毫升以内', 3);
INSERT INTO `init_home_nursing_info` VALUES (64, 11, '一天800毫升以内', 2);
INSERT INTO `init_home_nursing_info` VALUES (65, 11, '一天1000毫升以内', 1);
INSERT INTO `init_home_nursing_info` VALUES (66, 11, '一天1000毫升以上', 0);
INSERT INTO `init_home_nursing_info` VALUES (67, 12, '基本不补', 5);
INSERT INTO `init_home_nursing_info` VALUES (68, 12, '一天1种', 4);
INSERT INTO `init_home_nursing_info` VALUES (69, 12, '一天2种', 3);
INSERT INTO `init_home_nursing_info` VALUES (70, 12, '一天3种', 2);
INSERT INTO `init_home_nursing_info` VALUES (71, 12, '一天4种', 1);
INSERT INTO `init_home_nursing_info` VALUES (72, 12, '一天4种以上', 0);
INSERT INTO `init_home_nursing_info` VALUES (73, 13, '基本不喝', 5);
INSERT INTO `init_home_nursing_info` VALUES (74, 13, '每天1小罐', 4);
INSERT INTO `init_home_nursing_info` VALUES (75, 13, '每天2小罐', 3);
INSERT INTO `init_home_nursing_info` VALUES (76, 13, '每天3小罐', 2);
INSERT INTO `init_home_nursing_info` VALUES (77, 13, '每天4小罐', 1);
INSERT INTO `init_home_nursing_info` VALUES (78, 13, '每天4小罐以上', 0);
INSERT INTO `init_home_nursing_info` VALUES (79, 14, '正常', 5);
INSERT INTO `init_home_nursing_info` VALUES (80, 14, '偶尔挑食', 4);
INSERT INTO `init_home_nursing_info` VALUES (81, 14, '有时挑食，', 3);
INSERT INTO `init_home_nursing_info` VALUES (82, 14, '总是挑食', 2);
INSERT INTO `init_home_nursing_info` VALUES (83, 14, '饭量很大', 1);
INSERT INTO `init_home_nursing_info` VALUES (84, 14, '饭量很小', 0);
INSERT INTO `init_home_nursing_info` VALUES (85, 15, '穿着正常', 5);
INSERT INTO `init_home_nursing_info` VALUES (86, 15, '穿着有点多/有点少', 4);
INSERT INTO `init_home_nursing_info` VALUES (87, 15, '穿着有时多/有时少', 3);
INSERT INTO `init_home_nursing_info` VALUES (88, 15, '穿着经常多/经常少', 2);
INSERT INTO `init_home_nursing_info` VALUES (89, 15, '穿着很多/很少', 1);
INSERT INTO `init_home_nursing_info` VALUES (90, 15, '穿着非常多/非常少', 0);
INSERT INTO `init_home_nursing_info` VALUES (91, 16, '室内温度正常', 5);
INSERT INTO `init_home_nursing_info` VALUES (92, 16, '室内温度有点高/有点低', 4);
INSERT INTO `init_home_nursing_info` VALUES (93, 16, '室内温度有时高/有时低', 3);
INSERT INTO `init_home_nursing_info` VALUES (94, 16, '室内温度经常高/经常低', 2);
INSERT INTO `init_home_nursing_info` VALUES (95, 16, '室内温度很高/很低', 1);
INSERT INTO `init_home_nursing_info` VALUES (96, 16, '室内温度非常高/非常低', 0);
INSERT INTO `init_home_nursing_info` VALUES (97, 17, '非常统一', 5);
INSERT INTO `init_home_nursing_info` VALUES (98, 17, '偶尔统一', 4);
INSERT INTO `init_home_nursing_info` VALUES (99, 17, '有时统一', 3);
INSERT INTO `init_home_nursing_info` VALUES (100, 17, '经常不能统一', 2);
INSERT INTO `init_home_nursing_info` VALUES (101, 17, '总是不统一', 1);
INSERT INTO `init_home_nursing_info` VALUES (102, 17, '完全不统一', 0);
INSERT INTO `init_home_nursing_info` VALUES (103, 18, '可以完全不用上', 5);
INSERT INTO `init_home_nursing_info` VALUES (104, 18, '偶尔送一次两次', 4);
INSERT INTO `init_home_nursing_info` VALUES (105, 18, '有时送', 3);
INSERT INTO `init_home_nursing_info` VALUES (106, 18, '经常送', 2);
INSERT INTO `init_home_nursing_info` VALUES (107, 18, '总是需要送', 1);
INSERT INTO `init_home_nursing_info` VALUES (108, 18, '无人看管，必须送', 0);
INSERT INTO `init_home_nursing_info` VALUES (109, 19, '正常，可以严格控制在大风，过热或过寒天气外出', 5);
INSERT INTO `init_home_nursing_info` VALUES (110, 19, '偶尔在大风，过热或过寒天气外出', 4);
INSERT INTO `init_home_nursing_info` VALUES (111, 19, '有时在大风，过热或过寒天气外出', 3);
INSERT INTO `init_home_nursing_info` VALUES (112, 19, '经常在大风，过热或过寒天气外出', 2);
INSERT INTO `init_home_nursing_info` VALUES (113, 19, '总是在大风，过热或过寒天气外出', 1);
INSERT INTO `init_home_nursing_info` VALUES (114, 19, '完全不控制', 0);
INSERT INTO `init_home_nursing_info` VALUES (115, 20, '正常', 5);
INSERT INTO `init_home_nursing_info` VALUES (116, 20, '偶尔参加，可以控制不参加', 4);
INSERT INTO `init_home_nursing_info` VALUES (117, 20, '有时参加', 3);
INSERT INTO `init_home_nursing_info` VALUES (118, 20, '经常参加', 2);
INSERT INTO `init_home_nursing_info` VALUES (119, 20, '总是参加', 1);
INSERT INTO `init_home_nursing_info` VALUES (120, 20, '生病也必须参加', 0);
COMMIT;

-- ----------------------------
-- Table structure for init_home_nursing_type
-- ----------------------------
DROP TABLE IF EXISTS `init_home_nursing_type`;
CREATE TABLE `init_home_nursing_type` (
  `type_id` int(11) NOT NULL AUTO_INCREMENT,
  `type_name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`type_id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='家庭护理类型表';

-- ----------------------------
-- Records of init_home_nursing_type
-- ----------------------------
BEGIN;
INSERT INTO `init_home_nursing_type` VALUES (1, '母亲孕期饮食');
INSERT INTO `init_home_nursing_type` VALUES (2, '母亲怀孕生产');
INSERT INTO `init_home_nursing_type` VALUES (3, '父母体质');
INSERT INTO `init_home_nursing_type` VALUES (4, '喂养哺乳情况');
INSERT INTO `init_home_nursing_type` VALUES (5, '家族过敏体质遗传');
INSERT INTO `init_home_nursing_type` VALUES (6, '家庭护理人员数量');
INSERT INTO `init_home_nursing_type` VALUES (7, '家庭饮食护理条件');
INSERT INTO `init_home_nursing_type` VALUES (8, '外出就餐频率 ');
INSERT INTO `init_home_nursing_type` VALUES (9, '水果/零食食用频率和量');
INSERT INTO `init_home_nursing_type` VALUES (10, '肉类食用频率和量');
INSERT INTO `init_home_nursing_type` VALUES (11, '喝牛奶，奶粉频率');
INSERT INTO `init_home_nursing_type` VALUES (12, '补品保健品/海参/燕窝/钙剂/复合维生素/');
INSERT INTO `init_home_nursing_type` VALUES (13, '喝酸奶频率');
INSERT INTO `init_home_nursing_type` VALUES (14, '饭量');
INSERT INTO `init_home_nursing_type` VALUES (15, '家庭穿衣护理条件');
INSERT INTO `init_home_nursing_type` VALUES (16, '家庭室内外温控');
INSERT INTO `init_home_nursing_type` VALUES (17, '家庭护理人员意见');
INSERT INTO `init_home_nursing_type` VALUES (18, '上幼儿园/早教/小学');
INSERT INTO `init_home_nursing_type` VALUES (19, '户外活动频率');
INSERT INTO `init_home_nursing_type` VALUES (20, '参加体育运动频率，如游泳/打篮球/踢足球/上体育课/跑步/跳舞/跳绳/跆拳道/轮滑/体能训练');
COMMIT;

-- ----------------------------
-- Table structure for init_label_info
-- ----------------------------
DROP TABLE IF EXISTS `init_label_info`;
CREATE TABLE `init_label_info` (
  `label_id` int(11) NOT NULL AUTO_INCREMENT,
  `label_name` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`label_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='标签信息表';

-- ----------------------------
-- Table structure for init_pay_type
-- ----------------------------
DROP TABLE IF EXISTS `init_pay_type`;
CREATE TABLE `init_pay_type` (
  `pay_id` int(11) NOT NULL AUTO_INCREMENT,
  `pay_name` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`pay_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='支付类型表';

-- ----------------------------
-- Table structure for init_point_info
-- ----------------------------
DROP TABLE IF EXISTS `init_point_info`;
CREATE TABLE `init_point_info` (
  `point_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '穴位id',
  `type_id` int(11) DEFAULT NULL COMMENT '穴位类型',
  `point_name` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '穴位名称',
  PRIMARY KEY (`point_id`)
) ENGINE=InnoDB AUTO_INCREMENT=154 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='穴位信息表';

-- ----------------------------
-- Records of init_point_info
-- ----------------------------
BEGIN;
INSERT INTO `init_point_info` VALUES (1, 1, '开天门');
INSERT INTO `init_point_info` VALUES (2, 1, '推坎宫');
INSERT INTO `init_point_info` VALUES (3, 1, '揉太阳');
INSERT INTO `init_point_info` VALUES (4, 1, '耳后高骨');
INSERT INTO `init_point_info` VALUES (5, 1, '囟门');
INSERT INTO `init_point_info` VALUES (6, 1, '百会');
INSERT INTO `init_point_info` VALUES (7, 1, '上星');
INSERT INTO `init_point_info` VALUES (8, 1, '印堂');
INSERT INTO `init_point_info` VALUES (9, 1, '攒竹');
INSERT INTO `init_point_info` VALUES (10, 1, '鱼腰');
INSERT INTO `init_point_info` VALUES (11, 1, '睛明');
INSERT INTO `init_point_info` VALUES (12, 1, '丝竹空');
INSERT INTO `init_point_info` VALUES (13, 1, '承泣');
INSERT INTO `init_point_info` VALUES (14, 1, '四白');
INSERT INTO `init_point_info` VALUES (15, 1, '球后');
INSERT INTO `init_point_info` VALUES (16, 1, '承浆');
INSERT INTO `init_point_info` VALUES (17, 1, '上迎香');
INSERT INTO `init_point_info` VALUES (18, 1, '下迎香');
INSERT INTO `init_point_info` VALUES (19, 1, '通鼻');
INSERT INTO `init_point_info` VALUES (20, 1, '  风池 □拿  □揉');
INSERT INTO `init_point_info` VALUES (21, 1, '风府');
INSERT INTO `init_point_info` VALUES (22, 1, '天柱骨□下推□刮');
INSERT INTO `init_point_info` VALUES (23, 1, '桥弓');
INSERT INTO `init_point_info` VALUES (24, 1, '角孙');
INSERT INTO `init_point_info` VALUES (25, 1, '扁桃体外方');
INSERT INTO `init_point_info` VALUES (26, 1, ' 廉泉');
INSERT INTO `init_point_info` VALUES (27, 1, '翳风');
INSERT INTO `init_point_info` VALUES (28, 2, '一窝风');
INSERT INTO `init_point_info` VALUES (29, 2, '内关穴');
INSERT INTO `init_point_info` VALUES (30, 2, '外关穴');
INSERT INTO `init_point_info` VALUES (31, 2, '膊阳池');
INSERT INTO `init_point_info` VALUES (32, 2, '三关');
INSERT INTO `init_point_info` VALUES (33, 2, '天河水 □清□取');
INSERT INTO `init_point_info` VALUES (34, 2, '六腑');
INSERT INTO `init_point_info` VALUES (35, 2, '曲池□拍 □揉 □刮');
INSERT INTO `init_point_info` VALUES (36, 2, '曲泽□拍 □揉 □刮');
INSERT INTO `init_point_info` VALUES (37, 2, '尺泽□拍 □揉□刮');
INSERT INTO `init_point_info` VALUES (38, 3, '小天心  □揉□捣');
INSERT INTO `init_point_info` VALUES (39, 3, '总筋');
INSERT INTO `init_point_info` VALUES (40, 3, '内劳宫');
INSERT INTO `init_point_info` VALUES (41, 3, '运内八卦');
INSERT INTO `init_point_info` VALUES (42, 3, '板门 □清 □清补□揉 □运');
INSERT INTO `init_point_info` VALUES (43, 3, '胃经');
INSERT INTO `init_point_info` VALUES (44, 3, '脾经□清 □清补 □补');
INSERT INTO `init_point_info` VALUES (45, 3, '肝经');
INSERT INTO `init_point_info` VALUES (46, 3, '心经');
INSERT INTO `init_point_info` VALUES (47, 3, '肺经□清 □清补 □补');
INSERT INTO `init_point_info` VALUES (48, 3, '肾经');
INSERT INTO `init_point_info` VALUES (49, 3, '肾顶');
INSERT INTO `init_point_info` VALUES (50, 3, '肾纹');
INSERT INTO `init_point_info` VALUES (51, 3, '大肠□清 □清补 □补');
INSERT INTO `init_point_info` VALUES (52, 3, '小肠□清 □清补 □补');
INSERT INTO `init_point_info` VALUES (53, 3, '二马');
INSERT INTO `init_point_info` VALUES (54, 3, '运水入土');
INSERT INTO `init_point_info` VALUES (55, 3, '运土入水');
INSERT INTO `init_point_info` VALUES (56, 3, '手阴阳□分阴□分阳□分阴阳');
INSERT INTO `init_point_info` VALUES (57, 3, '四横纹');
INSERT INTO `init_point_info` VALUES (58, 3, '四缝□揉□掐□针刺');
INSERT INTO `init_point_info` VALUES (59, 3, '小横纹');
INSERT INTO `init_point_info` VALUES (60, 3, '掌小横纹');
INSERT INTO `init_point_info` VALUES (61, 3, '五指节');
INSERT INTO `init_point_info` VALUES (62, 3, '左端正');
INSERT INTO `init_point_info` VALUES (63, 3, '右端正');
INSERT INTO `init_point_info` VALUES (64, 3, '外劳宫');
INSERT INTO `init_point_info` VALUES (65, 3, '外八卦');
INSERT INTO `init_point_info` VALUES (66, 3, '列缺');
INSERT INTO `init_point_info` VALUES (67, 3, '合谷');
INSERT INTO `init_point_info` VALUES (68, 3, '少商□掐□放血');
INSERT INTO `init_point_info` VALUES (69, 3, '商阳□掐□放血');
INSERT INTO `init_point_info` VALUES (70, 3, '十宣');
INSERT INTO `init_point_info` VALUES (71, 3, '五指节');
INSERT INTO `init_point_info` VALUES (72, 3, '老龙');
INSERT INTO `init_point_info` VALUES (73, 3, '二扇门');
INSERT INTO `init_point_info` VALUES (74, 3, '威灵');
INSERT INTO `init_point_info` VALUES (75, 3, '精宁');
INSERT INTO `init_point_info` VALUES (76, 4, '天突');
INSERT INTO `init_point_info` VALUES (77, 4, '璇玑');
INSERT INTO `init_point_info` VALUES (78, 4, '膻中□揉□分推');
INSERT INTO `init_point_info` VALUES (79, 4, '胸八道□分推□刮');
INSERT INTO `init_point_info` VALUES (80, 4, '乳根');
INSERT INTO `init_point_info` VALUES (81, 4, '乳旁');
INSERT INTO `init_point_info` VALUES (82, 4, '云门');
INSERT INTO `init_point_info` VALUES (83, 4, '中府');
INSERT INTO `init_point_info` VALUES (84, 4, '肋胁');
INSERT INTO `init_point_info` VALUES (85, 4, '期门');
INSERT INTO `init_point_info` VALUES (86, 4, '日月');
INSERT INTO `init_point_info` VALUES (87, 5, '大椎 □下推□刮 □揉□挤捏');
INSERT INTO `init_point_info` VALUES (88, 5, '肩井');
INSERT INTO `init_point_info` VALUES (89, 5, '肩胛骨');
INSERT INTO `init_point_info` VALUES (90, 5, '风门');
INSERT INTO `init_point_info` VALUES (91, 5, '肺俞');
INSERT INTO `init_point_info` VALUES (92, 5, '厥阴');
INSERT INTO `init_point_info` VALUES (93, 5, '心俞');
INSERT INTO `init_point_info` VALUES (94, 5, '肝俞');
INSERT INTO `init_point_info` VALUES (95, 5, '膈俞');
INSERT INTO `init_point_info` VALUES (96, 5, '脾俞');
INSERT INTO `init_point_info` VALUES (97, 5, '胃俞');
INSERT INTO `init_point_info` VALUES (98, 5, '肾俞');
INSERT INTO `init_point_info` VALUES (99, 5, '大肠俞');
INSERT INTO `init_point_info` VALUES (100, 5, '小肠俞');
INSERT INTO `init_point_info` VALUES (101, 5, '膀胱俞');
INSERT INTO `init_point_info` VALUES (102, 5, '脊柱□上推□下推□刮');
INSERT INTO `init_point_info` VALUES (103, 5, '捏脊□上捏□下捏');
INSERT INTO `init_point_info` VALUES (104, 5, '膀胱经□拔□刮');
INSERT INTO `init_point_info` VALUES (105, 5, '七节骨□上推□下推');
INSERT INTO `init_point_info` VALUES (106, 5, '龟尾');
INSERT INTO `init_point_info` VALUES (107, 5, '工字背');
INSERT INTO `init_point_info` VALUES (108, 6, '上脘');
INSERT INTO `init_point_info` VALUES (109, 6, '中脘');
INSERT INTO `init_point_info` VALUES (110, 6, '下脘');
INSERT INTO `init_point_info` VALUES (111, 6, '下脘');
INSERT INTO `init_point_info` VALUES (112, 6, '神阙');
INSERT INTO `init_point_info` VALUES (113, 6, '天枢');
INSERT INTO `init_point_info` VALUES (114, 6, '大横');
INSERT INTO `init_point_info` VALUES (115, 6, '丹田');
INSERT INTO `init_point_info` VALUES (116, 6, '气海');
INSERT INTO `init_point_info` VALUES (117, 6, '关元');
INSERT INTO `init_point_info` VALUES (118, 6, '肚角');
INSERT INTO `init_point_info` VALUES (119, 6, '腹阴阳');
INSERT INTO `init_point_info` VALUES (120, 6, '摩腹');
INSERT INTO `init_point_info` VALUES (121, 7, '足三里');
INSERT INTO `init_point_info` VALUES (122, 7, '三阴交');
INSERT INTO `init_point_info` VALUES (123, 7, '箕门');
INSERT INTO `init_point_info` VALUES (124, 7, '百虫');
INSERT INTO `init_point_info` VALUES (125, 7, '外膝眼');
INSERT INTO `init_point_info` VALUES (126, 7, '丰隆');
INSERT INTO `init_point_info` VALUES (127, 7, '委中');
INSERT INTO `init_point_info` VALUES (128, 7, '前承山');
INSERT INTO `init_point_info` VALUES (129, 7, '后承山');
INSERT INTO `init_point_info` VALUES (130, 7, '阳灵泉');
INSERT INTO `init_point_info` VALUES (131, 7, '阴灵泉');
INSERT INTO `init_point_info` VALUES (132, 7, '解溪');
INSERT INTO `init_point_info` VALUES (133, 7, '照海');
INSERT INTO `init_point_info` VALUES (134, 7, '大敦');
INSERT INTO `init_point_info` VALUES (135, 7, '隐白');
INSERT INTO `init_point_info` VALUES (136, 7, '仆参');
INSERT INTO `init_point_info` VALUES (137, 7, '太冲');
INSERT INTO `init_point_info` VALUES (138, 7, '昆仑');
INSERT INTO `init_point_info` VALUES (139, 7, '太溪');
INSERT INTO `init_point_info` VALUES (140, 7, '涌泉');
INSERT INTO `init_point_info` VALUES (141, 8, '摇抖肘法');
INSERT INTO `init_point_info` VALUES (142, 8, '打马过天河');
INSERT INTO `init_point_info` VALUES (143, 8, '黄蜂入洞');
INSERT INTO `init_point_info` VALUES (144, 8, '水底捞明月');
INSERT INTO `init_point_info` VALUES (145, 8, '飞经走气');
INSERT INTO `init_point_info` VALUES (146, 8, '按弦走搓摩');
INSERT INTO `init_point_info` VALUES (147, 8, '二龙戏珠');
INSERT INTO `init_point_info` VALUES (148, 8, '苍龙摆尾');
INSERT INTO `init_point_info` VALUES (149, 8, '猿猴摘果');
INSERT INTO `init_point_info` VALUES (150, 8, '揉脐及龟尾并擦七节骨');
INSERT INTO `init_point_info` VALUES (151, 8, '赤凤点头');
INSERT INTO `init_point_info` VALUES (152, 8, '凤凰展翅');
INSERT INTO `init_point_info` VALUES (153, 8, '按肩井');
COMMIT;

-- ----------------------------
-- Table structure for init_point_type
-- ----------------------------
DROP TABLE IF EXISTS `init_point_type`;
CREATE TABLE `init_point_type` (
  `type_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '类型id',
  `type_name` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '类型名称',
  `type_order` int(2) DEFAULT NULL COMMENT '类型排序',
  `type_state` int(1) DEFAULT NULL COMMENT '类型状态',
  PRIMARY KEY (`type_id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='穴位类型表';

-- ----------------------------
-- Records of init_point_type
-- ----------------------------
BEGIN;
INSERT INTO `init_point_type` VALUES (1, '头面部穴位', 1, 1);
INSERT INTO `init_point_type` VALUES (2, '前臂穴位', 2, 1);
INSERT INTO `init_point_type` VALUES (3, '手部穴位', 3, 1);
INSERT INTO `init_point_type` VALUES (4, '前胸穴位', 4, 1);
INSERT INTO `init_point_type` VALUES (5, '后背穴位', 5, 1);
INSERT INTO `init_point_type` VALUES (6, '腹部', 6, 1);
INSERT INTO `init_point_type` VALUES (7, '下肢穴位', 7, 1);
INSERT INTO `init_point_type` VALUES (8, '复式手法', 8, 1);
INSERT INTO `init_point_type` VALUES (9, '自定义', 9, 1);
COMMIT;

-- ----------------------------
-- Table structure for init_push_info
-- ----------------------------
DROP TABLE IF EXISTS `init_push_info`;
CREATE TABLE `init_push_info` (
  `push_id` int(11) NOT NULL COMMENT '推送类别',
  `push_name` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '推送名称',
  PRIMARY KEY (`push_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='大夫推送类别信息表';

-- ----------------------------
-- Table structure for init_service_info
-- ----------------------------
DROP TABLE IF EXISTS `init_service_info`;
CREATE TABLE `init_service_info` (
  `service_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '推拿ID',
  `service_type` int(11) DEFAULT NULL COMMENT '推拿类别',
  `service_label` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '标签',
  `service_name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '名称',
  `service_img` varchar(400) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '图片',
  `service_cost` decimal(6,2) DEFAULT '0.00' COMMENT '售价',
  `service_income` decimal(6,2) DEFAULT '0.00' COMMENT '收益',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP,
  `service_status` int(1) DEFAULT '0',
  PRIMARY KEY (`service_id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='推拿信息表';

-- ----------------------------
-- Records of init_service_info
-- ----------------------------
BEGIN;
INSERT INTO `init_service_info` VALUES (1, 1, NULL, '一般推拿', 'https://ss1.bdstatic.com/70cFvXSh_Q1YnxGkpoWK1HF6hhy/it/u=1062877500,3069326377&fm=27&gp=0.jpg', 198.00, 19.80, '2018-03-01 16:12:07', 1);
INSERT INTO `init_service_info` VALUES (2, 2, NULL, '中级推拿', 'https://ss0.bdstatic.com/70cFvHSh_Q1YnxGkpoWK1HF6hhy/it/u=1812759398,944877370&fm=27&gp=0.jpg', 298.00, 29.80, '2018-03-01 16:12:09', 1);
INSERT INTO `init_service_info` VALUES (8, NULL, NULL, '高级小儿推拿', 'http://47.92.39.186:80/image/image_tmp/20180419111956_5667.png', 398.00, 0.00, '2018-04-19 11:19:59', 0);
COMMIT;

-- ----------------------------
-- Table structure for init_service_type
-- ----------------------------
DROP TABLE IF EXISTS `init_service_type`;
CREATE TABLE `init_service_type` (
  `type_id` int(11) NOT NULL AUTO_INCREMENT,
  `type_name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='推拿分类表';

-- ----------------------------
-- Table structure for sys_account_card_info
-- ----------------------------
DROP TABLE IF EXISTS `sys_account_card_info`;
CREATE TABLE `sys_account_card_info` (
  `card_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '会员卡ID',
  `card_name` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '会员卡名称',
  `card_img` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '图片',
  `card_type` int(11) DEFAULT '0' COMMENT '1满减，2体验券，3优惠，4充值，5记次卡',
  `card_value` int(10) DEFAULT NULL COMMENT '会员卡面值（计次卡为null）',
  `account_discount` decimal(8,2) DEFAULT '0.00' COMMENT '会员卡优惠策略',
  `card_state` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT '1' COMMENT '0:下架；1上架',
  `service_id` int(11) DEFAULT NULL COMMENT '选择的服务项目',
  `card_count` int(11) DEFAULT NULL COMMENT '次卡的次数',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP,
  `valid_time` int(4) DEFAULT NULL COMMENT '有效期',
  `is_delete` int(11) DEFAULT '0' COMMENT '是否删除  1 删除 0 未删除',
  PRIMARY KEY (`card_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='卡项（储值卡，计次卡）信息表';

-- ----------------------------
-- Table structure for sys_discount_card_info
-- ----------------------------
DROP TABLE IF EXISTS `sys_discount_card_info`;
CREATE TABLE `sys_discount_card_info` (
  `card_id` int(11) NOT NULL AUTO_INCREMENT,
  `card_type` int(11) DEFAULT NULL COMMENT '1满减，2体验券，3优惠，4充值，5记次卡',
  `card_name` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '卡名称',
  `card_no` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT '1' COMMENT '卡编号',
  `card_total_time` int(11) DEFAULT '1' COMMENT '计次卡总次数',
  `card_cost` decimal(10,2) DEFAULT '0.00' COMMENT '实际售价',
  `discount_cost` decimal(10,2) DEFAULT '0.00' COMMENT '出售售价（实际售价 > 出售售价）',
  `target_cost` decimal(10,2) DEFAULT NULL COMMENT '目标价格(满减券使用)',
  `discount_costs` decimal(10,2) DEFAULT NULL COMMENT '优惠价格(满减券使用)',
  `valid_day` varchar(11) COLLATE utf8mb4_unicode_ci DEFAULT '30' COMMENT '有效天数',
  `discount_desc` varchar(300) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '使用说明',
  `subclinic_ids` int(11) DEFAULT NULL COMMENT '可使用门店(0为所有门店，门店id为对应门店)',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP,
  `card_state` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT '0' COMMENT '0:下架；1上架',
  `service_id` int(11) DEFAULT NULL COMMENT '体验卷是用到，选择的服务项目',
  `card_img` varchar(300) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_delete` int(1) DEFAULT '0' COMMENT '0未删除，1删除',
  `card_count` int(3) DEFAULT NULL COMMENT '发放数量',
  `share_full_url` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '分享地址',
  `share_short_url` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '分享地址的短链接',
  PRIMARY KEY (`card_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='优惠券信息表';

-- ----------------------------
-- Table structure for sys_discount_card_type
-- ----------------------------
DROP TABLE IF EXISTS `sys_discount_card_type`;
CREATE TABLE `sys_discount_card_type` (
  `type_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '类别主键ID',
  `type_name` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '类别名称',
  PRIMARY KEY (`type_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='优惠券类别管理';

-- ----------------------------
-- Records of sys_discount_card_type
-- ----------------------------
BEGIN;
INSERT INTO `sys_discount_card_type` VALUES (1, '满减券');
INSERT INTO `sys_discount_card_type` VALUES (2, '体验券');
INSERT INTO `sys_discount_card_type` VALUES (3, '通用券');
INSERT INTO `sys_discount_card_type` VALUES (4, '充值卡');
INSERT INTO `sys_discount_card_type` VALUES (5, '计次卡');
COMMIT;

-- ----------------------------
-- Table structure for sys_function_info
-- ----------------------------
DROP TABLE IF EXISTS `sys_function_info`;
CREATE TABLE `sys_function_info` (
  `function_id` int(11) NOT NULL AUTO_INCREMENT,
  `menu_id` int(11) DEFAULT NULL,
  `menu_name` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `function_name` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `role_id` int(11) DEFAULT NULL,
  `insert_but` int(11) DEFAULT NULL COMMENT '是否：0否，1是',
  `select_but` int(11) DEFAULT NULL COMMENT '是否：0否，1是',
  `update_but` int(11) DEFAULT NULL COMMENT '是否：0否，1是',
  `delete_but` int(11) DEFAULT NULL COMMENT '是否：0否，1是',
  PRIMARY KEY (`function_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=46 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='系统模块功能表';

-- ----------------------------
-- Records of sys_function_info
-- ----------------------------
BEGIN;
INSERT INTO `sys_function_info` VALUES (1, 1, '工作台', '查看商品消耗详情', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_function_info` VALUES (2, 1, '工作台', '绿色通道', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_function_info` VALUES (3, 1, '工作台', '新增预约', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_function_info` VALUES (4, 1, '工作台', '快速开卡', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_function_info` VALUES (5, 1, '工作台', '会员储值', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_function_info` VALUES (6, 1, '工作台', '新增会员', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_function_info` VALUES (7, 1, '工作台', '退款申请审批', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_function_info` VALUES (8, 2, '预约管理', '预约列表', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_function_info` VALUES (9, 2, '预约管理', '预约看板', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_function_info` VALUES (10, 2, '预约管理', '新增预约', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_function_info` VALUES (11, 2, '预约管理', '接诊', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_function_info` VALUES (12, 3, '订单管理', '绿色通道', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_function_info` VALUES (13, 3, '订单管理', '订单详情', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_function_info` VALUES (14, 4, '病人库', '导出患者病历信息', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_function_info` VALUES (15, 4, '病人库', '查看患者详细信息', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_function_info` VALUES (16, 4, '病人库', '编辑患者信息', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_function_info` VALUES (17, 4, '病人库', '查看家庭护理详情', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_function_info` VALUES (18, 4, '病人库', '查看随访记录', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_function_info` VALUES (19, 5, '会员中心', '添加会员', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_function_info` VALUES (20, 5, '会员中心', '查看会员详情', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_function_info` VALUES (21, 5, '会员中心', '申请退款', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_function_info` VALUES (22, 5, '会员中心', '查看订单详情', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_function_info` VALUES (23, 5, '会员中心', '会员储值', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_function_info` VALUES (24, 6, '卡券管理', '卡项管理', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_function_info` VALUES (25, 6, '卡券管理', '优惠券管理', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_function_info` VALUES (26, 6, '卡券管理', '添加/编辑/下架/删除卡项', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_function_info` VALUES (27, 6, '卡券管理', '添加/下架/编辑/删除优惠券', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_function_info` VALUES (28, 6, '卡券管理', '发放优惠券', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_function_info` VALUES (29, 6, '卡券管理', '分享优惠券', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_function_info` VALUES (30, 7, '门店管理', '任命店长', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_function_info` VALUES (31, 7, '门店管理', '项目设置', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_function_info` VALUES (32, 7, '门店管理', '商品设置', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_function_info` VALUES (33, 7, '门店管理', '查看商品消耗统计', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_function_info` VALUES (34, 8, '员工管理', '添加员工', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_function_info` VALUES (35, 8, '员工管理', '查看已离职员工', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_function_info` VALUES (36, 8, '员工管理', '查看员工绩效', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_function_info` VALUES (37, 8, '员工管理', '辞退员工', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_function_info` VALUES (38, 8, '员工管理', '恢复员工', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_function_info` VALUES (39, 8, '员工管理', '员工离职', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_function_info` VALUES (40, 9, '基础设置', '总店广播设置', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_function_info` VALUES (41, 9, '基础设置', '分店广播设置', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_function_info` VALUES (42, 9, '基础设置', '总店轮播设置', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_function_info` VALUES (43, 9, '基础设置', '分店轮播设置', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_function_info` VALUES (44, 9, '基础设置', '职位设置', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_function_info` VALUES (45, 999, '系统设置', '查询全部门店', NULL, NULL, NULL, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_menu_function_rel
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu_function_rel`;
CREATE TABLE `sys_menu_function_rel` (
  `rel_id` int(11) NOT NULL AUTO_INCREMENT,
  `menu_id` int(11) DEFAULT NULL,
  `menu_name` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `function_id` int(11) DEFAULT NULL,
  `function_name` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `role_id` int(11) DEFAULT NULL,
  `insert_but` int(11) DEFAULT NULL COMMENT '是否：0否，1是',
  `select_but` int(11) DEFAULT NULL COMMENT '是否：0否，1是',
  `update_but` int(11) DEFAULT NULL COMMENT '是否：0否，1是',
  `delete_but` int(11) DEFAULT NULL COMMENT '是否：0否，1是',
  PRIMARY KEY (`rel_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of sys_menu_function_rel
-- ----------------------------
BEGIN;
INSERT INTO `sys_menu_function_rel` VALUES (1, 1, '工作台', 1, '查看商品消耗详情', 1, 1, 1, 1, 1);
INSERT INTO `sys_menu_function_rel` VALUES (2, 1, '工作台', 2, '绿色通道', 1, 1, 0, 0, 0);
INSERT INTO `sys_menu_function_rel` VALUES (3, 999, '系统设置', 45, '查询全部门店', 1, 1, 1, 1, 1);
COMMIT;

-- ----------------------------
-- Table structure for sys_menu_info
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu_info`;
CREATE TABLE `sys_menu_info` (
  `menu_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '菜单主键ID',
  `menu_name` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '菜单名称',
  `menu_url` varchar(100) CHARACTER SET utf8 DEFAULT NULL COMMENT '菜单地址',
  `menu_status` int(1) DEFAULT '0' COMMENT '当前状态:0:启用;1:停用',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`menu_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1000 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='菜单信息表';

-- ----------------------------
-- Records of sys_menu_info
-- ----------------------------
BEGIN;
INSERT INTO `sys_menu_info` VALUES (1, '工作台', NULL, 1, '2018-03-21 11:48:21');
INSERT INTO `sys_menu_info` VALUES (2, '预约管理', NULL, 1, '2018-03-21 11:55:41');
INSERT INTO `sys_menu_info` VALUES (3, '订单管理', NULL, 1, '2018-03-21 11:55:48');
INSERT INTO `sys_menu_info` VALUES (4, '病人库', NULL, 1, '2018-03-21 11:56:11');
INSERT INTO `sys_menu_info` VALUES (5, '会员中心', NULL, 1, '2018-03-21 11:56:20');
INSERT INTO `sys_menu_info` VALUES (6, '卡券管理', NULL, 1, '2018-03-21 11:56:29');
INSERT INTO `sys_menu_info` VALUES (7, '门店管理', NULL, 1, '2018-03-21 11:56:37');
INSERT INTO `sys_menu_info` VALUES (8, '员工管理', NULL, 1, '2018-03-21 11:56:49');
INSERT INTO `sys_menu_info` VALUES (9, '基础设置', NULL, 1, '2018-03-21 11:56:58');
INSERT INTO `sys_menu_info` VALUES (999, '系统设置', NULL, 0, '2018-04-25 10:48:56');
COMMIT;

-- ----------------------------
-- Table structure for sys_role_info
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_info`;
CREATE TABLE `sys_role_info` (
  `role_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '角色主键ID',
  `role_name` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '角色名称',
  `role_status` int(11) DEFAULT '0' COMMENT '当前状态:0:启用;1:停用',
  `subclinic_ids` varchar(0) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '门店设置',
  `subclinic_name` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '门店',
  `role_desc` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '备注',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`role_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='角色信息表（管理员，分店管理员，大夫）';

-- ----------------------------
-- Records of sys_role_info
-- ----------------------------
BEGIN;
INSERT INTO `sys_role_info` VALUES (1, '医师', 1, NULL, NULL, NULL, '2018-02-27 10:02:08');
INSERT INTO `sys_role_info` VALUES (2, '管理员', 1, NULL, NULL, NULL, '2018-03-08 15:16:29');
COMMIT;

-- ----------------------------
-- Table structure for sys_role_menu_rel
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_menu_rel`;
CREATE TABLE `sys_role_menu_rel` (
  `rel_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '角色菜单表主键ID',
  `role_id` int(11) DEFAULT NULL COMMENT '角色ID',
  `menu_id` int(11) DEFAULT NULL COMMENT '菜单ID',
  `rel_status` int(1) NOT NULL DEFAULT '0' COMMENT '当前状态:0:停用;1:启用',
  PRIMARY KEY (`rel_id`),
  KEY `role_id` (`role_id`),
  KEY `menu_id` (`menu_id`),
  CONSTRAINT `sys_role_menu_rel_ibfk_1` FOREIGN KEY (`role_id`) REFERENCES `sys_role_info` (`role_id`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `sys_role_menu_rel_ibfk_2` FOREIGN KEY (`menu_id`) REFERENCES `sys_menu_info` (`menu_id`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='角色菜单关联表';

-- ----------------------------
-- Table structure for sys_user_info
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_info`;
CREATE TABLE `sys_user_info` (
  `user_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '用户ID',
  `user_no` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '员工编号，登录用',
  `user_name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '用户真实姓名',
  `user_phone` varchar(11) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '用户手机',
  `user_pwd` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '用户密码',
  `user_gender` int(1) DEFAULT '1' COMMENT '用户性别:0:男;1:女',
  `user_img` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT 'http://testxrtn.ggling.com/children/frontend/web/uploads/img/2018-03-14/20180314172404.png' COMMENT '用户头像/职业照',
  `user_level` int(2) DEFAULT '1' COMMENT '级别:0',
  `subclinic_id` int(13) DEFAULT NULL COMMENT '所属分店ID',
  `user_role` int(2) DEFAULT '1' COMMENT '用户角色',
  `user_status` int(1) DEFAULT '0' COMMENT '当前状态:0:在职;1:离职；2辞退',
  `leave_time` datetime DEFAULT NULL COMMENT '员工离职时间',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '员工入职时间',
  `user_source` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '员工来源',
  PRIMARY KEY (`user_id`),
  KEY `user_role` (`user_role`),
  KEY `subclinic_id` (`subclinic_id`),
  KEY `user_level` (`user_level`),
  CONSTRAINT `sys_user_info_ibfk_1` FOREIGN KEY (`user_role`) REFERENCES `sys_role_info` (`role_id`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `sys_user_info_ibfk_2` FOREIGN KEY (`subclinic_id`) REFERENCES `t_subclinic_info` (`subclinic_id`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `sys_user_info_ibfk_3` FOREIGN KEY (`user_level`) REFERENCES `init_grade_doctor` (`grade_id`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=56 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='后台员工表（系统人员）\r\n\r\n';

-- ----------------------------
-- Records of sys_user_info
-- ----------------------------
BEGIN;
INSERT INTO `sys_user_info` VALUES (1, 'GYT000001', '王立军', '13312341230', 'e10adc3949ba59abbe56e057f20f883e', 1, 'https://ss1.bdstatic.com/70cFuXSh_Q1YnxGkpoWK1HF6hhy/it/u=2043305675,3979419376&fm=200&gp=0.jpg', 2, 1, 1, 0, '2018-04-02 21:32:20', '2018-02-27 10:04:01', NULL);
INSERT INTO `sys_user_info` VALUES (7, 'GYT000002', '张运杰', '13312341231', 'e10adc3949ba59abbe56e057f20f883e', 1, 'http://syb.ruipengwang.com:8082/syb_admin/download/images/zyj.jpg', 3, 1, 1, 0, '2018-04-26 14:03:02', '2018-03-04 14:05:48', '招聘2');
INSERT INTO `sys_user_info` VALUES (8, 'GYT000003', '王红霞', '13312341232', 'e10adc3949ba59abbe56e057f20f883e', 0, 'http://47.92.39.186:80/image/image_tmp/20180425170247_8805.png', 4, 3, 1, 0, '2018-03-08 15:15:26', '2018-03-09 15:14:54', '大麦网');
INSERT INTO `sys_user_info` VALUES (9, 'GYT000004', '李云飞', '13312341233', 'e10adc3949ba59abbe56e057f20f883e', 0, 'http://www.yuntuhaiwai.com/uploads/allimg/170208/1-1F20P95536240.jpg', 1, 2, 1, 0, NULL, '2018-03-09 15:16:36', '1');
INSERT INTO `sys_user_info` VALUES (11, 'GYT000005', '邱白河', '13312341234', 'e10adc3949ba59abbe56e057f20f883e', 1, 'http://syb.ruipengwang.com:8082/syb_admin/download/images/zyj.jpg', 1, 2, 1, 0, '2018-03-09 16:49:13', '2018-03-09 16:48:38', '1');
INSERT INTO `sys_user_info` VALUES (12, 'GYT000006', '徐如曦', '13312341235', 'e10adc3949ba59abbe56e057f20f883e', 1, 'http://www.yuntuhaiwai.com/uploads/allimg/170208/1-1F20P95536240.jpg', 4, 1, 1, 0, NULL, '2018-03-04 14:05:48', '招聘2');
INSERT INTO `sys_user_info` VALUES (50, 'GYT000007', '林淑芬', '13312341236', 'e10adc3949ba59abbe56e057f20f883e', 1, 'http://img02.tooopen.com/images/20160525/tooopen_sy_163302833538.jpg', 1, 3, 1, 0, NULL, '2018-04-03 09:38:53', NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_version_info
-- ----------------------------
DROP TABLE IF EXISTS `sys_version_info`;
CREATE TABLE `sys_version_info` (
  `version_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '版本主键ID',
  `version_code` int(11) DEFAULT NULL COMMENT '当前版本号',
  `version_name` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '版本名称',
  `update_title` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '标题',
  `is_update` int(1) DEFAULT '0' COMMENT '是否强更：0:是;1:否',
  `update_info` varchar(300) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '更新内容',
  `equipment_type` int(1) DEFAULT NULL COMMENT '设备类型:0:安卓;1:ios',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_url` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '更新地址',
  PRIMARY KEY (`version_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='APP版本信息表';

-- ----------------------------
-- Records of sys_version_info
-- ----------------------------
BEGIN;
INSERT INTO `sys_version_info` VALUES (1, 1, '1', '版本升级', 0, '1、修复部分闪退bug\\n2、新增医生可以请假', 1, '2018-03-04 12:12:06', 'http://www.baidu.com');
INSERT INTO `sys_version_info` VALUES (2, 1, '1', '1', 1, '1、修复部分闪退bug\\n2、新增医生可以请假', 0, '2018-03-04 12:47:33', 'http://www.baidu.com');
COMMIT;

-- ----------------------------
-- Table structure for t_backcard_info
-- ----------------------------
DROP TABLE IF EXISTS `t_backcard_info`;
CREATE TABLE `t_backcard_info` (
  `backcard_id` int(11) NOT NULL AUTO_INCREMENT,
  `subclinic_id` int(11) DEFAULT NULL COMMENT '分店id',
  `apply_user_id` int(11) DEFAULT NULL COMMENT '申请退款人id',
  `apply_user_name` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '退款人姓名',
  `apply_user_phone` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '退款人手机号',
  `apply_reason` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '退款理由',
  `back_account` decimal(10,2) DEFAULT NULL COMMENT '退款金额',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`backcard_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='退款信息表\n';

-- ----------------------------
-- Table structure for t_booking_info
-- ----------------------------
DROP TABLE IF EXISTS `t_booking_info`;
CREATE TABLE `t_booking_info` (
  `booking_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '预约表主键ID',
  `booking_no` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '预约编号',
  `user_id` int(11) DEFAULT NULL COMMENT '预约用户ID',
  `doctor_id` int(11) DEFAULT NULL COMMENT '预约大夫ID',
  `subclinic_id` int(11) DEFAULT NULL COMMENT '预约分店ID',
  `user_name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '会员姓名',
  `user_gender` int(1) DEFAULT '0' COMMENT '性别:默认0:男;1:女',
  `user_phone` varchar(11) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '用户电话',
  `user_phones` varchar(11) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '备用人手机号',
  `is_first` int(1) DEFAULT '0' COMMENT '是否初诊:0:是;1:否',
  `booking_status` int(1) DEFAULT '0' COMMENT '当前状态:0:待就诊;1:已迟到;2:调理中;3:待支付;4:已完成;5:取消;6:已接诊',
  `booking_time` datetime DEFAULT NULL COMMENT '就诊时间',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `booking_desc` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '备注',
  `cancel_time` datetime DEFAULT NULL COMMENT '取消预约时间',
  `cancel_type` int(11) DEFAULT NULL COMMENT '取消类型（1：用户 2：商家）',
  `booking_source` int(1) DEFAULT NULL COMMENT '0:微信;1到店',
  PRIMARY KEY (`booking_id`),
  KEY `user_id` (`user_id`),
  KEY `t_booking_info_ibfk_2` (`subclinic_id`),
  CONSTRAINT `t_booking_info_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `t_user_info` (`user_id`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `t_booking_info_ibfk_2` FOREIGN KEY (`subclinic_id`) REFERENCES `t_subclinic_info` (`subclinic_id`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='患者预约信息表\r\n';

-- ----------------------------
-- Records of t_booking_info
-- ----------------------------
BEGIN;
INSERT INTO `t_booking_info` VALUES (1, 'GYT20180428001000326', 2, 55, 1, '12', 0, '18520193300', NULL, 0, 6, '2018-04-28 12:00:00', '2018-04-28 10:55:14', '1', NULL, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for t_card_usr_rel
-- ----------------------------
DROP TABLE IF EXISTS `t_card_usr_rel`;
CREATE TABLE `t_card_usr_rel` (
  `rel_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL COMMENT '用户ID',
  `card_id` int(11) DEFAULT NULL COMMENT '卡ID',
  `service_id` int(11) DEFAULT NULL COMMENT '推拿服务id',
  `subclinic_id` int(11) DEFAULT NULL COMMENT '使用门店',
  `create_time` datetime DEFAULT NULL COMMENT '开卡时间',
  `card_left_time` int(11) DEFAULT NULL COMMENT '计次卡剩余次数',
  `invalid_time` datetime DEFAULT NULL,
  PRIMARY KEY (`rel_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='用户办卡关系表';

-- ----------------------------
-- Table structure for t_coupon_usr_rel
-- ----------------------------
DROP TABLE IF EXISTS `t_coupon_usr_rel`;
CREATE TABLE `t_coupon_usr_rel` (
  `rel_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `coupon_id` int(11) DEFAULT NULL COMMENT '优惠劵id',
  `coupon_createtime` datetime DEFAULT NULL COMMENT '领取时间',
  `is_used` int(11) DEFAULT '0' COMMENT '是否使用:0:未使用;1:使用',
  `use_time` datetime DEFAULT NULL COMMENT '使用时间',
  `card_type` int(1) DEFAULT NULL COMMENT '1满减，2体验券，3通用，4充值，5记次卡',
  PRIMARY KEY (`rel_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='用户优惠券关系表';

-- ----------------------------
-- Table structure for t_doctor_month_rel
-- ----------------------------
DROP TABLE IF EXISTS `t_doctor_month_rel`;
CREATE TABLE `t_doctor_month_rel` (
  `month_id` int(11) NOT NULL COMMENT 'id',
  `month_str` varchar(7) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '月份',
  `doctor_id` int(11) DEFAULT NULL COMMENT '用户id',
  `order_number` int(4) DEFAULT NULL COMMENT '订单数',
  `reply_ratio` decimal(2,2) DEFAULT NULL COMMENT '满意度',
  `complain_ratio` decimal(2,2) DEFAULT NULL COMMENT '投诉率',
  `month_treatment_ratio` decimal(2,2) DEFAULT NULL COMMENT '月治愈率',
  `user_level` int(1) DEFAULT NULL COMMENT '等级',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`month_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Table structure for t_doctor_push_rel
-- ----------------------------
DROP TABLE IF EXISTS `t_doctor_push_rel`;
CREATE TABLE `t_doctor_push_rel` (
  `rel_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '关系ID',
  `doctor_id` int(11) DEFAULT NULL COMMENT '大夫ID',
  `push_id` int(11) DEFAULT NULL COMMENT '推送类别ID',
  `is_open` int(1) DEFAULT '0' COMMENT '是否开启:0:开启;1:关闭',
  `patient_id` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `booking_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`rel_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='大夫推送关系表';

-- ----------------------------
-- Table structure for t_off_info
-- ----------------------------
DROP TABLE IF EXISTS `t_off_info`;
CREATE TABLE `t_off_info` (
  `off_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL COMMENT '医生ID',
  `off_day` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '请假日期',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '提交日期',
  PRIMARY KEY (`off_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='请假信息表';

-- ----------------------------
-- Table structure for t_order_goods_detail
-- ----------------------------
DROP TABLE IF EXISTS `t_order_goods_detail`;
CREATE TABLE `t_order_goods_detail` (
  `rel_id` int(11) NOT NULL AUTO_INCREMENT,
  `booking_id` int(32) DEFAULT NULL COMMENT '预约单号',
  `order_id` int(11) DEFAULT NULL COMMENT '订单号',
  `order_no` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '订单号',
  `goods_type` int(11) DEFAULT NULL COMMENT '商品分类',
  `goods_id` int(11) DEFAULT NULL COMMENT '商品id',
  `cashier_id` int(32) DEFAULT NULL COMMENT '收款人',
  `user_id` int(32) DEFAULT NULL COMMENT '用户id',
  `doctor_id` int(32) DEFAULT NULL COMMENT '大夫',
  `subclinic_id` int(32) DEFAULT NULL COMMENT '分店',
  `patient_id` int(11) DEFAULT NULL COMMENT '患者',
  `order_num` int(1) DEFAULT '1' COMMENT '订单数量',
  `goods_name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '商品名称',
  `goods_img` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '图片',
  `goods_cost` decimal(8,2) DEFAULT '0.00' COMMENT '单价',
  `goods_income` decimal(8,2) DEFAULT '0.00' COMMENT '提成',
  `goods_sum_income` decimal(10,2) DEFAULT NULL COMMENT '总提成',
  `goods_sum_cost` decimal(10,2) DEFAULT '0.00' COMMENT '总金额',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`rel_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='推拿服务详情表（商品订单）';

-- ----------------------------
-- Table structure for t_order_info
-- ----------------------------
DROP TABLE IF EXISTS `t_order_info`;
CREATE TABLE `t_order_info` (
  `order_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '订单主键Id',
  `booking_id` int(32) DEFAULT NULL COMMENT '预约单号',
  `order_no` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '订单编号',
  `pay_no` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '支付平台支付单号',
  `cashier_id` int(11) DEFAULT NULL COMMENT '收款人id',
  `user_id` int(11) DEFAULT NULL COMMENT '用户',
  `doctor_id` int(11) DEFAULT NULL COMMENT '大夫',
  `subclinic_id` int(11) DEFAULT NULL COMMENT '分店',
  `patient_id` int(11) DEFAULT NULL COMMENT '患者',
  `coupon_id` int(11) DEFAULT NULL COMMENT '优惠券id',
  `card_id` varchar(11) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '次卡id',
  `order_total_cost` decimal(12,2) DEFAULT '0.00' COMMENT '应付金额',
  `order_pay_cost` decimal(12,2) DEFAULT '0.00' COMMENT '实付金额',
  `coupon_total_cost` decimal(6,2) DEFAULT '0.00' COMMENT '优惠金额',
  `doctor_cost` decimal(6,2) DEFAULT NULL COMMENT '大夫提成',
  `pay_way` int(1) DEFAULT '0' COMMENT '支付方式:0:余额;1:支付宝二维码;2:微信二维码;3:现金;4:信用卡;5:次卡',
  `order_state` int(1) DEFAULT '1' COMMENT '订单状态:0:完成;1:未接诊;2:调理中;3:待支付;4:已关闭',
  `pay_state` int(1) DEFAULT '1' COMMENT '付款状态:0:已付款;1:未付款',
  `order_time` datetime DEFAULT NULL COMMENT '收款时间',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `is_reply` int(1) DEFAULT '0' COMMENT '是否评价（0为为评价，1为已评价）',
  PRIMARY KEY (`order_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='订单信息表';

-- ----------------------------
-- Table structure for t_order_service_detail
-- ----------------------------
DROP TABLE IF EXISTS `t_order_service_detail`;
CREATE TABLE `t_order_service_detail` (
  `rel_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '推拿服务表主键ID',
  `booking_id` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '预约单号',
  `order_id` int(11) DEFAULT NULL COMMENT '订单ID',
  `order_no` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '订单号',
  `service_type` int(11) DEFAULT NULL COMMENT '推拿类别',
  `service_id` int(11) DEFAULT NULL COMMENT '推拿Id',
  `cashier_id` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '收款人',
  `user_id` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '用户id',
  `doctor_id` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '大夫',
  `subclinic_id` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '分店',
  `patient_id` int(11) DEFAULT NULL COMMENT '患者',
  `order_num` int(1) DEFAULT '1' COMMENT '订单数量',
  `service_name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '推拿名称',
  `service_img` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '图片',
  `service_cost` decimal(8,2) DEFAULT '0.00' COMMENT '单价',
  `service_income` decimal(8,2) DEFAULT '0.00' COMMENT '收益',
  `service_sum_cost` decimal(10,2) DEFAULT '0.00' COMMENT '总和',
  `service_sum_income` decimal(10,2) DEFAULT '0.00' COMMENT '总收益',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`rel_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='推拿服务详情表（服务订单）';

-- ----------------------------
-- Table structure for t_patient_history
-- ----------------------------
DROP TABLE IF EXISTS `t_patient_history`;
CREATE TABLE `t_patient_history` (
  `history_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL COMMENT '患者id',
  `just_now_history` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '现病史',
  `allergy_history` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '过敏史',
  `user_history` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '个人史',
  `family_history` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '家族史',
  `vaccine_history` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '疫苗接种历史',
  `laboratory_history` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '实验室辅助检查',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`history_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='患者历史档案';

-- ----------------------------
-- Table structure for t_patient_info
-- ----------------------------
DROP TABLE IF EXISTS `t_patient_info`;
CREATE TABLE `t_patient_info` (
  `patient_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '患者主键ID',
  `user_id` int(11) DEFAULT NULL COMMENT '家长ID',
  `patient_name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '患者姓名',
  `patient_img` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT 'https://assets.dxycdn.com/app/DXYClinic/business/images/child-avatar.png' COMMENT '患者头像',
  `patient_age` int(1) DEFAULT '1' COMMENT '患者年龄',
  `patient_gender` int(1) DEFAULT '0' COMMENT '用户性别:0:男;1:女',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `patient_height` int(4) DEFAULT '50' COMMENT '身高',
  `patient_body_weight` int(4) DEFAULT '20' COMMENT '体重',
  `patient_address` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '地址',
  `patient_desc` varchar(300) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '备注',
  `patient_birthday` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '生日',
  PRIMARY KEY (`patient_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='患者信息表';

-- ----------------------------
-- Table structure for t_patient_init
-- ----------------------------
DROP TABLE IF EXISTS `t_patient_init`;
CREATE TABLE `t_patient_init` (
  `rel_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '基础信息表ID',
  `booking_id` int(11) DEFAULT NULL COMMENT '预约号ID',
  `patient_id` int(11) DEFAULT NULL COMMENT '患者ID',
  `user_name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '患者姓名',
  `user_gender` int(1) DEFAULT '0' COMMENT '患者性别：0:男;1:女',
  `user_birthday` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '患者生日',
  `user_height` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '患者身高',
  `user_body_weight` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '患者体重',
  `user_address` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '患者地址',
  `user_desc` varchar(300) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '备注',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '接诊时间',
  `user_source` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT '' COMMENT '用户来源 如0线下；1线上',
  `therapy_status` int(1) DEFAULT '1' COMMENT '接诊状态:1,2,3,4',
  `user_img` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT 'https://assets.dxycdn.com/app/DXYClinic/business/images/child-avatar.png' COMMENT '头像',
  `user_age` int(11) DEFAULT '1' COMMENT '年龄',
  PRIMARY KEY (`rel_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='患者基础信息调查表';

-- ----------------------------
-- Table structure for t_patient_treatment
-- ----------------------------
DROP TABLE IF EXISTS `t_patient_treatment`;
CREATE TABLE `t_patient_treatment` (
  `treatment_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '就诊记录ID',
  `user_id` int(11) DEFAULT NULL COMMENT '用户ID',
  `patient_id` int(11) DEFAULT NULL COMMENT '患者ID',
  `booking_id` int(11) DEFAULT NULL COMMENT '预约ID',
  `treatment_time` datetime DEFAULT NULL COMMENT '就诊时间',
  `disease_time` datetime DEFAULT NULL COMMENT '发病时间',
  `disease_info` varchar(300) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '主诉',
  `treatment_info` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '主症:1,2,3  - 暂未使用',
  `treatment_desc` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '兼症           - 暂未使用',
  `disease_history` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '现病史       - 暂未使用',
  `sensitive_history` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '过敏史       - 暂未使用',
  `todo_history` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '其他信息   - 暂未使用',
  `treatment_init` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '初步就诊',
  `treatment_opinion` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '治疗意见',
  `treatment_remarks` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '备注',
  `treatment_img` text COLLATE utf8mb4_unicode_ci COMMENT '舌苔图片',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `hands_img` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '手部照片',
  `face_img` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '面部照片',
  `treatment_state` int(1) DEFAULT '0' COMMENT '0未完成，1完成',
  PRIMARY KEY (`treatment_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='病历信息表';

-- ----------------------------
-- Table structure for t_reply_info
-- ----------------------------
DROP TABLE IF EXISTS `t_reply_info`;
CREATE TABLE `t_reply_info` (
  `reply_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '评论表主键ID',
  `order_id` int(32) DEFAULT NULL COMMENT '订单ID',
  `doctor_id` int(11) DEFAULT NULL COMMENT '大夫ID',
  `user_id` int(11) DEFAULT NULL COMMENT '用户ID',
  `user_name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '用户名',
  `user_img` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '用户图片',
  `reply_integral` int(1) DEFAULT '0' COMMENT '评分值',
  `reply_info` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '回复内容',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`reply_id`),
  KEY `user_id` (`user_id`),
  KEY `t_reply_info_ibfk_2` (`doctor_id`),
  CONSTRAINT `t_reply_info_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `t_user_info` (`user_id`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `t_reply_info_ibfk_2` FOREIGN KEY (`doctor_id`) REFERENCES `sys_user_info` (`user_id`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='医生评价信息表';

-- ----------------------------
-- Table structure for t_subclinic_info
-- ----------------------------
DROP TABLE IF EXISTS `t_subclinic_info`;
CREATE TABLE `t_subclinic_info` (
  `subclinic_id` int(13) NOT NULL AUTO_INCREMENT COMMENT '分店主键ID',
  `subclinic_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '分店名称',
  `subclinic_logo` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '分店LOGO',
  `subclinic_phone` varchar(11) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '分店联系方式',
  `subclinic_start_time` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '营业开始时间',
  `subclinic_end_time` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '营业结束时间',
  `subclinic_address` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '分店地址',
  `subclinic_lat_lon` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '分店所在经纬度',
  `subclinic_desc` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '备注',
  `subclinic_status` int(1) DEFAULT '0' COMMENT '当前状态:0:启用;1:停用',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `owner_id` int(11) DEFAULT NULL COMMENT '店长id',
  PRIMARY KEY (`subclinic_id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='分店信息表';

-- ----------------------------
-- Records of t_subclinic_info
-- ----------------------------
BEGIN;
INSERT INTO `t_subclinic_info` VALUES (1, '金街分部', 'http://testxrtn.ggling.com/children/frontend/web/uploads/img/2018-03-10/shijingshan.png', NULL, '9', '24', '北京市顺义区金街国际大厦A座402（中医院对面、华联、新世界旁）', '40.125996,116.653076', '特大喜讯，小儿推拿即将与2月3号开启专家门诊', 1, '2018-03-13 16:28:40', 7);
INSERT INTO `t_subclinic_info` VALUES (2, '石园分部', 'http://testxrtn.ggling.com/children/frontend/web/uploads/img/2018-03-10/shiyuan.png', NULL, '9', '24', '北京市顺义区石园东区甲7号底商（联通大楼对面、美廉美斜对面）', '40.109280,116.667790', 'Hold住抗生素——宿迁市中医院小儿推拿护佑儿童健康', 1, '2018-03-13 16:28:40', 9);
INSERT INTO `t_subclinic_info` VALUES (3, '国泰宏城分部', 'http://testxrtn.ggling.com/children/frontend/web/uploads/img/2018-03-10/guotai.png', NULL, '9', '24', '北京市顺义区石门国泰宏城购物广场2层', '40.129650,116.635080', '特大喜讯，小儿推拿即将与2月3号开启专家门诊', 1, '2018-03-13 16:28:40', 50);
INSERT INTO `t_subclinic_info` VALUES (4, '马坡分部', 'http://testxrtn.ggling.com/children/frontend/web/uploads/img/2018-03-10/mapo.png', NULL, '9', '24', '北京市顺义区香悦四季西区南门物业对面底商（大大国际英语西50米）', '40.180300,116.651373', '特大喜讯，小儿推拿即将与2月3号开启专家门诊', 1, '2018-03-13 16:28:40', NULL);
INSERT INTO `t_subclinic_info` VALUES (5, '祥云小镇分部', 'http://testxrtn.ggling.com/children/frontend/web/uploads/img/2018-03-10/xiangyun.png', NULL, '9', '24', '北京市顺义区后沙峪祥云小镇南区安泰大街6号院8-1（美吉姆斜对面）', '40.087230,116.538300', 'Hold住抗生素——宿迁市中医院小儿推拿护佑儿童健康', 1, '2018-03-13 16:28:40', NULL);
INSERT INTO `t_subclinic_info` VALUES (6, '天通苑分部', 'http://testxrtn.ggling.com/children/frontend/web/uploads/img/2018-03-10/tiantongyuan.png', NULL, '9', '24', '北京市昌平区太平庄中街京妮儿童汇东门1层（自安然酒店旁）', '40.068990,116.416150', '特大喜讯，小儿推拿即将与2月3号开启专家门诊', 1, '2018-03-13 16:28:40', NULL);
INSERT INTO `t_subclinic_info` VALUES (7, '回龙观分部', 'http://testxrtn.ggling.com/children/frontend/web/uploads/img/2018-03-10/huilongguan.png', NULL, '9', '24', '北京市昌平区龙跃苑东5区3号楼北面底商（童学园幼儿园斜对面，霍营地铁E口向西400米）', '40.073100,116.355240', '特大喜讯，小儿推拿即将与2月3号开启专家门诊', 1, '2018-03-13 16:28:40', NULL);
INSERT INTO `t_subclinic_info` VALUES (8, '怀柔分部', 'http://testxrtn.ggling.com/children/frontend/web/uploads/img/2018-03-10/huairou.png', NULL, '9', '24', '北京市怀柔区府前西街新悦百货3层（怀柔区第一中学对面）', '40.314100,116.629170', 'Hold住抗生素——宿迁市中医院小儿推拿护佑儿童健康', 1, '2018-03-13 16:28:40', NULL);
INSERT INTO `t_subclinic_info` VALUES (9, '通州分部', 'http://testxrtn.ggling.com/children/frontend/web/uploads/img/2018-03-10/tongzhou.png', NULL, '9', '24', '北京市通州区梨园南街临河里33号，京妮儿童汇2层（华业东方玫瑰）', '39.880860,116.681240', '特大喜讯，小儿推拿即将与2月3号开启专家门诊', 1, '2018-03-13 16:28:40', NULL);
INSERT INTO `t_subclinic_info` VALUES (10, '密云分部', 'http://testxrtn.ggling.com/children/frontend/web/uploads/img/2018-03-10/miyun.png', NULL, '9', '24', '北京市密云区鼓楼南大街16号国泰百货2层', '40.374902,116.846518', '特大喜讯，小儿推拿即将与2月3号开启专家门诊', 1, '2018-03-13 16:28:40', NULL);
INSERT INTO `t_subclinic_info` VALUES (11, '北苑分部', 'http://testxrtn.ggling.com/children/frontend/web/uploads/img/2018-03-10/beiyuan.png', NULL, '9', '24', '北京市朝阳区北苑路42号K酷时尚广场3层（北辰购物中心对面）', '40.033000,116.418660', 'Hold住抗生素——宿迁市中医院小儿推拿护佑儿童健康Hold住抗生素——宿迁市中医院小儿推拿护佑儿童健康', 1, '2018-03-13 16:28:38', NULL);
INSERT INTO `t_subclinic_info` VALUES (12, '丰台分部 ', 'http://testxrtn.ggling.com/children/frontend/web/uploads/img/2018-03-10/fengtai.png', NULL, '9', '24', '北京市丰台区丰台北路79号华堂商场3层（七里庄地铁A口冠京大厦）', '39.867150,116.293660', '特大喜讯，小儿推拿即将与2月3号开启专家门诊', 1, '2018-03-13 16:13:46', NULL);
INSERT INTO `t_subclinic_info` VALUES (13, '石景山分部', 'http://testxrtn.ggling.com/children/frontend/web/uploads/img/2018-03-10/shijingshan.png', NULL, '9', '24', '北京市石景山区石景山路31号盛景国际广场4号楼2层（石景山游乐园西侧）', '39.908275,116.201125', '特大喜讯，小儿推拿即将与2月3号开启专家门诊', 1, '2018-03-13 16:13:53', NULL);
INSERT INTO `t_subclinic_info` VALUES (14, '颐美佳分部', 'http://testxrtn.ggling.com/children/frontend/web/uploads/img/2018-03-10/yimeijia.png', NULL, '9', '24', '北京市海淀区西四环北路136号颐美佳医院', '39.937850,116.276110', 'Hold住抗生素——宿迁市中医院小儿推拿护佑儿童健康', 1, '2018-03-13 16:13:58', NULL);
INSERT INTO `t_subclinic_info` VALUES (15, '燕郊分部', 'http://testxrtn.ggling.com/children/frontend/web/uploads/img/2018-03-10/yanjiao.png', NULL, '9', '24', '河北省燕郊三河市燕郊富地广场C座一层底商（吉野家往东100米）', '39.964092,116.814568', '特大喜讯，小儿推拿即将与2月3号开启专家门诊', 1, '2018-03-13 16:14:03', NULL);
INSERT INTO `t_subclinic_info` VALUES (16, '香港分部', 'http://testxrtn.ggling.com/children/frontend/web/uploads/img/2018-03-10/xianggang.png', NULL, '9', '24', '香港九龙弥敦道602-608总统商业大厦13层', '22.313790,114.175190', '特大喜讯，小儿推拿即将与2月3号开启专家门诊', 1, '2018-03-13 16:14:09', NULL);
INSERT INTO `t_subclinic_info` VALUES (17, '纽约分部', 'http://testxrtn.ggling.com/children/frontend/web/uploads/img/2018-03-10/jinjie.png', NULL, '9', '24', '美国纽约58大道5834号\nNO.5834  58ts  Ave  NY  USA', '36.438961,-76.530762', 'Hold住抗生素——宿迁市中医院小儿推拿护佑儿童健康', 1, '2018-03-13 16:14:14', NULL);
INSERT INTO `t_subclinic_info` VALUES (18, '温哥华分部', 'http://testxrtn.ggling.com/children/frontend/web/uploads/img/2018-03-10/shiyuan.png', NULL, '9', '24', '加拿大温哥华骑士Knight街2615号\nNO.2615 Knight  Ave Vancouver  BC  Canada  V5N2P9', '62.021528,-142.382813', '特大喜讯，小儿推拿即将与2月3号开启专家门诊', 1, '2018-03-13 16:14:19', NULL);
INSERT INTO `t_subclinic_info` VALUES (19, '伦敦分部', 'http://testxrtn.ggling.com/children/frontend/web/uploads/img/2018-03-10/guotai.png', NULL, '9', '24', '英国伦敦西区Askew路217号皇家游行街4号\n4 Kings Parade , 217 Askew Road ,West London  W12 9BA', '62.794935,14.589844', '特大喜讯，小儿推拿即将与2月3号开启专家门诊', 1, '2018-03-13 16:14:24', NULL);
INSERT INTO `t_subclinic_info` VALUES (20, '开发区分部', 'http://testxrtn.ggling.com/children/frontend/web/uploads/img/2018-03-10/mapo.png', NULL, '9', '24', '天津廊坊开发区北凤道南100米阳光佳和社区服务中心2层', '39.553180,116.738430', 'Hold住抗生素——宿迁市中医院小儿推拿护佑儿童健康', 1, '2018-03-13 16:17:37', NULL);
COMMIT;

-- ----------------------------
-- Table structure for t_user_card_consumer_rel
-- ----------------------------
DROP TABLE IF EXISTS `t_user_card_consumer_rel`;
CREATE TABLE `t_user_card_consumer_rel` (
  `consumer_id` int(11) NOT NULL COMMENT '主键ID',
  `user_id` int(11) DEFAULT NULL COMMENT '用户ID',
  `card_id` int(11) DEFAULT NULL COMMENT '1满减，2体验券，3优惠，4充值，5记次卡',
  `consumer_money` decimal(10,0) DEFAULT NULL COMMENT '消费金额',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`consumer_id`),
  KEY `t_user_card_consumer_rel_ibfk_1` (`user_id`),
  KEY `t_user_card_consumer_rel_ibfk_2` (`card_id`),
  CONSTRAINT `t_user_card_consumer_rel_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `t_user_info` (`user_id`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `t_user_card_consumer_rel_ibfk_2` FOREIGN KEY (`card_id`) REFERENCES `sys_account_card_info` (`card_id`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='用户充值卡消费信息表';

-- ----------------------------
-- Table structure for t_user_conclusion_rel
-- ----------------------------
DROP TABLE IF EXISTS `t_user_conclusion_rel`;
CREATE TABLE `t_user_conclusion_rel` (
  `rel_id` int(11) NOT NULL AUTO_INCREMENT,
  `booking_id` int(11) DEFAULT NULL COMMENT '预约id',
  `conclusion_id` int(11) DEFAULT NULL COMMENT '诊断结论id',
  `doctor_id` int(11) DEFAULT NULL COMMENT '医生id',
  `patient_id` int(11) DEFAULT NULL COMMENT '患者id',
  `user_id` int(11) DEFAULT NULL COMMENT '患者id',
  `conclusion_name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `subclinic_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`rel_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='病历诊断结论表';

-- ----------------------------
-- Table structure for t_user_disease_rel
-- ----------------------------
DROP TABLE IF EXISTS `t_user_disease_rel`;
CREATE TABLE `t_user_disease_rel` (
  `rel_id` int(11) NOT NULL AUTO_INCREMENT,
  `treatment_id` int(11) DEFAULT NULL COMMENT '病历id',
  `booking_id` int(11) DEFAULT NULL COMMENT '预约id',
  `user_id` int(11) DEFAULT NULL COMMENT '家长id',
  `patient_id` int(11) DEFAULT NULL COMMENT '患者id',
  `doctor_id` int(11) DEFAULT NULL COMMENT '医生id',
  `type_id` int(11) DEFAULT NULL COMMENT '病症类型id',
  `disease_id` int(11) DEFAULT NULL COMMENT '病症id',
  `type_name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `disease_name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_main` int(11) DEFAULT '0' COMMENT '是否主症:0:否;1:是;',
  `disease_score` int(1) DEFAULT NULL,
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `subclinic_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`rel_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='用户病症关系表';

-- ----------------------------
-- Table structure for t_user_info
-- ----------------------------
DROP TABLE IF EXISTS `t_user_info`;
CREATE TABLE `t_user_info` (
  `user_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '用户主键ID',
  `open_id` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '微信OpenId',
  `user_name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '用户姓名',
  `user_phone` varchar(11) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '用户手机号',
  `user_phones` varchar(11) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '备用手机号',
  `phone_code` varchar(4) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '手机验证码',
  `user_img` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT 'http://testxrtn.ggling.com/children/frontend/web/uploads/img/2018-03-14/20180314172404.png' COMMENT '用户头像',
  `user_account` decimal(12,2) DEFAULT '0.00' COMMENT '账户余额',
  `user_level` int(11) DEFAULT '1' COMMENT '会员当前等级',
  `user_birthday` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '用户生日',
  `user_gender` int(1) DEFAULT '0' COMMENT '用户性别:0:男;1:女',
  `user_from` int(22) DEFAULT '1' COMMENT '用户来源',
  `user_address` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '用户地址',
  `subclinic_id` int(11) DEFAULT NULL COMMENT '门店id',
  `user_wx` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '微信昵称',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `width` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '宽',
  `height` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '高',
  PRIMARY KEY (`user_id`),
  KEY `t_user_info_ibfk_1` (`user_level`),
  CONSTRAINT `t_user_info_ibfk_1` FOREIGN KEY (`user_level`) REFERENCES `init_grade_user` (`grade_id`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='会员信息表（用户信息表）';

-- ----------------------------
-- Records of t_user_info
-- ----------------------------
BEGIN;
INSERT INTO `t_user_info` VALUES (2, NULL, '12', '18520193300', NULL, NULL, 'http://testxrtn.ggling.com/children/frontend/web/uploads/img/2018-03-14/20180314172404.png', 0.00, 1, NULL, 0, 1, NULL, 1, NULL, '2018-04-28 10:55:14', NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for t_user_nersing_rel
-- ----------------------------
DROP TABLE IF EXISTS `t_user_nersing_rel`;
CREATE TABLE `t_user_nersing_rel` (
  `rel_id` int(11) NOT NULL AUTO_INCREMENT,
  `push_id` int(11) DEFAULT NULL COMMENT '推送ID',
  `booking_id` int(11) DEFAULT NULL COMMENT '预约id',
  `user_id` int(11) DEFAULT NULL COMMENT '家长id',
  `patient_id` int(11) DEFAULT NULL COMMENT '患者id',
  `doctor_id` int(11) DEFAULT NULL COMMENT '医生id',
  `type_id` int(11) DEFAULT NULL,
  `type_name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nursing_id` int(11) DEFAULT NULL,
  `nursing_name` text COLLATE utf8mb4_unicode_ci,
  `nursing_value` int(2) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  PRIMARY KEY (`rel_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Table structure for t_user_point_rel
-- ----------------------------
DROP TABLE IF EXISTS `t_user_point_rel`;
CREATE TABLE `t_user_point_rel` (
  `rel_id` int(11) NOT NULL AUTO_INCREMENT,
  `subclinic_id` int(11) DEFAULT NULL COMMENT '分店id',
  `booking_id` int(11) DEFAULT NULL COMMENT '预约id',
  `user_id` int(11) DEFAULT NULL COMMENT '家长id',
  `patient_id` int(11) DEFAULT NULL COMMENT '患者id',
  `doctor_id` int(11) DEFAULT NULL COMMENT '医生id',
  `type_id` int(11) DEFAULT NULL COMMENT '穴位类型id',
  `point_id` int(11) DEFAULT NULL COMMENT '穴位id',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `type_name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `point_name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`rel_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='穴位关系表';

-- ----------------------------
-- Table structure for t_user_treatment_rel
-- ----------------------------
DROP TABLE IF EXISTS `t_user_treatment_rel`;
CREATE TABLE `t_user_treatment_rel` (
  `rel_id` int(11) NOT NULL AUTO_INCREMENT,
  `treatment_id` int(11) DEFAULT NULL,
  `sum_value` int(3) DEFAULT NULL,
  `treatment_ratio` decimal(6,2) DEFAULT NULL,
  `doctor_id` int(11) DEFAULT NULL,
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`rel_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Table structure for token
-- ----------------------------
DROP TABLE IF EXISTS `token`;
CREATE TABLE `token` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `access_token` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `create_time` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Table structure for user_access_token
-- ----------------------------
DROP TABLE IF EXISTS `user_access_token`;
CREATE TABLE `user_access_token` (
  `id` int(11) NOT NULL,
  `access_token` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'access_token',
  `create_time` int(11) DEFAULT NULL COMMENT '生成时间',
  `jsapi_ticket` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'jsapi_ticket',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Table structure for user_code
-- ----------------------------
DROP TABLE IF EXISTS `user_code`;
CREATE TABLE `user_code` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '用户手机号',
  `rand_num` int(11) DEFAULT NULL COMMENT '验证码',
  `create_time` int(11) DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

SET FOREIGN_KEY_CHECKS = 1;
